Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Restore DB from backup file with multiple backup sets without FILE opt

Status
Not open for further replies.
password99

password99

Technical User
Jul 19, 2002
122
US
What happens if you restore a DB from a backup file that has many backup sets without specifyng the FILE option?
 
Sort by date Sort by votes
I beleive that it defaults to file = 1.

Denny

--Anything is possible. All it takes is a little research. (Me)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

intel233
  • Locked
  • Question
Backup/Restore DB from SQL issues
Replies
2
Views
157
intel233
intel233
baran121
  • Locked
  • Question
take a database from system databse place
Replies
2
Views
340
iambob
iambob
Rajesh Karunakaran
  • Locked
  • Question
Restoring/Importing data from 2 backup files one after the other
Replies
0
Views
112
Rajesh Karunakaran
Rajesh Karunakaran
DougNaf
  • Locked
  • Question
SQL 2016 - DB attachment and error 3415
Replies
1
Views
232
fredericofonseca
fredericofonseca
JoPaBC
  • Locked
  • Question
Schedule and automate backups of SQL Express databases in SQL Server Express 1
Replies
5
Views
481
JoPaBC
JoPaBC

Part and Inventory Search

Sponsor

Back
Top