April 29, 2008 at 9:52 am
Hi Techies
I have one SQL Server 2000 (SP4) Ent Ed on Windows 2003 R1 , during the mainitainace hour System Admin Screw up System and System Got Crashed . Now I have to Build the System Again . I have Full Backup of System DAtabase took 1 week ago and have User Databases backup taken at Weekend . I am able to get Data and Transaction files (MDF & LDF) from the system .
Can any one please help me how should i approach to Rebuild the System Again so that Everything should be recovered and less possiblility of data loss..
Any Help or Documents in this regards will be highy Appriciated .
Thanks in advance for your time ..
April 29, 2008 at 11:05 am
There are 2 things you could do at the same time.
Copy mdf and ldf and restoring the old backup file to the new server.
install SQL Server - to your current service pack
change start up parameter to do -m at a minimum ... there is a -T to as well but I forgot the which number...
stop sql server
replace old master .mdf and .ldf files so that you get the login and password info (always copy your files to a backup place)
start sql server
drop all suspect databases
reattach all databases using your old .mdf and .ldf
if you are changing from window 2000 to 2003, and you are using MSDTC you will need to modify 2003 server to allow MSDTC. It is enable on 2000 server, but on window 2003 you have to manually turn it on.
Good luck.
Sopheap
April 29, 2008 at 11:10 am
Thanks a lot Sophead.
I think u were talking about -T3608 Switch .
Really appriciate your reply.
April 29, 2008 at 11:25 am
By the way you should also do dbcc and another full backup once you are online.
Sopheap
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply