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!

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

backup of DBMeta,DBData, DBSystem?

Status
Not open for further replies.

yehong

Programmer
Sep 22, 2003
291
US
I have backup copies of SQL Server 2000 database. I have recived theree files.
dbnameMeta_db_111203.bak
dbnameSystem_db_111203.bak
dbnameData_db_111203.bak

How can the restore of this database be carried out? I have previously restored a database from a backup file using Restore Utility in the Enterprise Manager. Here I am bit confused as to which file I shoudl start backup with? Whether do it one by one or just one backup will start backukp of other files too?
Also, why do Meta and System need to be restored?
thanks,
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top