basic restore and database guidance | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

basic restore and database guidance

Though I have been developing on sql server for a year or so, I have little experience administrating sql server. We are running win2k with sql server 2k. I wanted to practice restoring the database in case we had a hard drive failure. I have been reading lots of articles but I have not been able to find anything which really explains how to do a full restore. <br /><br />Does anyone have any suggested reading that would give me best practice guidance on this procedure. <br /><br />So far I have set up a second server that is simular to the original. I have been able to restore many of the database from bak files using the restore tool. I have not been able to restore any of the tlog bak files. Also, I restored the master db yesterday first and that pretty much make my sql server inopperable. <br /><br />I would appreciate any guidance on the subject.<br /><br />Thanks,<br />Dan Cary<br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />~
I figured out how to restore all my databases the transaction logs minus the system databases. So please disregard the previous request. <br /><br />I would like to know what restoring the system master database, model and msdb would do for me. <br /><br />Also, any instructional referrences would be appreciated.<br /><br />Thanks,<br />Dan Cary<br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />~
Restoring Master, Msdb and Model you will have all information about users, jobs, etc.
Suppose you have full backup of your database.
Suppose also you have to install fresh copy of SQL.
If you restore only your database, you have to create users from de begining and jobs, etc.
Tha’s why, in short, why you have to backup system databases also.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
Agree with Luis’s refersnce and refer to thishttp://vyaskn.tripod.com/maintaining_standby_sql_server.htm link for more information on standby databases. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thanks for the advice. I guess this is why I am testing our backup and restore system. I wanted to see if it is adequate. I was able to restore the databases but I am getting errors whwn I try to restore the master. When I restored the master first, I had problems. So I restored all the other databases and then tried restoring the master. So far no good.
I will read the article you guys referenced and give an update later. I really appreciate the time.
Thanks,
Dan Cary
Restoring master database is no straight forward, refer to the books online for information and using REBUILDM utility you can accomplish the task. The link above refers the steps to resolve any issues. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>