June 15, 2006 at 9:44 pm
i have 5 database that got corrupted & error message is Torn page. after doing Hard Disk(HD) diagonistic there are some bad sector & finally decided to replace HD with NEW.here is what i want to understand & my question is.
SQL Server system files & tables is on Drive C:\ & database is on Drive E:\.
As we are going to replace the Drive E:\ & restore the Database on the NEW DRIVE which will be lable as Ddrive E:\. so what are the consequences in the terms of Internal working SQL Server. i need help to understand what should be my action plan to bring ny server up & runing with last good backset which i am going to restore. I want to know what i need to do before i do restore or think about doing database restore. Any help will be highly appreciated.
June 15, 2006 at 11:19 pm
I assume the torn pages were on the E: partition only. If you keep the drive label the same, restoring to the same path from the last good backup setup should work pretty smoothly. If you need to restore master as well, be sure to do that first. The other databases will show up as suspect, but that just means the files are missing -- a straight restore should do the trick.
Don't forget about MSDB either if you have any scheduled jobs.
Question: What sort of disk arrangement do you have? Most RAID controllers these day have a battery backup for memory cache, which eliminates the risk of torn pages. If you don't have such a controller, it's worth the investment...
June 16, 2006 at 2:36 am
Make sure you have all the login scripts as well as you will lose login maping after restoring the DB.
------------
Prakash Sawant
http://psawant.blogspot.com
June 16, 2006 at 8:07 am
First of all thank you for your replies. question about HD, where we are going to re-build Array & we don't have cache controller, but i agree to you that is an very good to way to handle this kind of situation. second thing i didn't get about MSDB job schedule. can you please give me some more information what you were asking about.
Coming back to the login scripts, i am sorry i don't have that. any lead on this will highly appreciated.
June 16, 2006 at 8:18 am
Let me first explain about MSDB.
if your db has some jobs shedule on it, all the information related to those jobs are stored in MSDB db which is system db, so it better to backup that as well as the job don't get backed up even if you take the db backup.
for login scrips you can get it from.
EM->Right click DB -> Generate SQL scripts -> options -> Script SQL server logins.
------------
Prakash Sawant
http://psawant.blogspot.com
June 16, 2006 at 9:00 am
Thank you prakash for your reply, i appreciate that.question about login scripts. As i am going to restore complete Database, so i have to create scripts from each databse including System database.as each DB will have different user. do we have something that will create scripts for all logins then going thru each individual. Also tolet you know that System DB are on Drive C: & User DB on Drive E:
Will appreciate you feedback ASAP.
June 16, 2006 at 9:42 am
This link might help you.
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
------------
Prakash Sawant
http://psawant.blogspot.com
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply