|
|
Posted by microsoft . public . sqlserver on 08/08/06 05:06
I have the back up of master(master_db.bak),
distribution(distribution_db.bak), model(model_db.bak, model_tlog.trn),
pubs(pubs_db.bak), Northwind(Northwind_db.bak),msdb(msdb_db.bak) and
compny(compny_db.bak,compny_db.trn). I have to restore all these
databases. What will be the correct sequence of Restoring these
databases so that I retain all the initial DB settinngs like
Replication, user logins and pwd, security settings and backup plans
etc. I have the database SQL server 7.0
Thanks for your guidance and help in advance.
Regards
Deepak Sinha
Navigation:
[Reply to this message]
|