Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
karuna
Aged Yak Warrior
582 Posts |
 Posted - 2002-12-06 : 14:09:48
|
| Hi, We have SQLServer 7.0 Standard Edition running on Winn NT 4.0, We have 4 user databases in that.As a part of Upgradation and other issues we are planning to format the HDD and re-install everything from the scratch,we need the 4 user databases after formatting and re-installing the S/W.What are the things should we do to restore the DBs after re-installing.KarunakaranDon't wait for things to happen,Make them to happen...Edited by - karuna on 12/06/2002 14:15:49 |
|
|
jsiedliski
Yak Posting Veteran
61 Posts |
Posted - 2002-12-06 : 14:25:17
|
| First of all, this is a pretty serious task if you are not very familiar with SQL Server, so PLEASE make sure you do your research.Regarding the user databases, you can do one of 2 things:1. Create backups for each db (and move to another server). When the server is rebuilt, do a restore of each db.2. Detach each db (move all files to another server) and when the server is rebuilt, re-attach the dbs.Here is where it gets more complex:If you have DTS packages / scheduled jobs, etc, you will want to take a back-up of the MSDB database. This db stores all this infomration. For the DTS packages, you could save each package indivitually as a .dts file, but that may take longer.If you use the model db, you will have to take a copy of this db as well.Lastly is the issue of users/user groups. If you do a fresh install of SQL Server, the user existing user accounts will be deleted. This information is stored in the Master db. Depending on how complex your server environment is, you may want to restore Master on the newly built server. ***Warning, I am pretty sure you can not restore Master from 7.0 to 2k *** don't know if you plan on upgrading, but this would be an issue if you are.I know some people shun on Books on Line, but microsoft did an exellent job documenting all this. check it out.Jack |
 |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2002-12-06 : 14:40:11
|
| Thanks Jack. I dont have Any Scheduled Jobs or any other DTS Packages, the DBs we have are basic things with some tables and few Stored Procs.As far as backups is it a must that the backup or detaching DB should be moved to another server?, with out moving to another server can I retrieve datas?...KarunakaranDon't wait for things to happen,Make them to happen... |
|
|
|
jsiedliski
Yak Posting Veteran
61 Posts |
Posted - 2002-12-06 : 14:52:25
|
| The reason I mentioned moving the .bak (or the database files) to a new server is that I thought you will do a "format C" on this server.Maybe I misunderstood, but the key is for you to store the files somewhere while you rebuild the exisitng server.Does that make sense? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-12-06 : 16:30:25
|
| I would also suggest testing the backup file by doing a restore onto another machine before performing the format on the hard drive. You wouldn't want to find out after you have rebuilt the server that the backup file is bad. What would you do then? You would have to go to an older backup file. |
|
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2002-12-07 : 08:26:09
|
| Thanks for the suggestions.KarunakaranDon't wait for things to happen,Make them to happen... |
|
|
|
|
|
|
|
|
Backup of DB Before formatting Hard Disk