July 25, 2003 at 12:32 pm
Hi Gurus,
Can any one pl. confirm step by step guideline to restore User databases to New Machine?.I am taking backup of my user databases on daily basis and Transaction log Backup at every 30 min through EM. I am also taking Backup of Master and MSDB just after completeting backup of my User databases?.One more think my EM backup is just creating only one file by the Extanson of .trn. I dont see any file name by the extanson of .Bak?. Is this a right way of taking the backup or I am missing some thing?. Any help would be highly appreciated.
July 25, 2003 at 2:01 pm
-- Take the backup on the Source DB and move it to the Target
-- Go to EM and choose Database-->Restore --> Select From Device-->Select Devices --> ADD --> Choose the copied back file
-- Go to option in the original menu and change the path to match your Drives
-- Restore
-- Repeat the same with TLog backups
-- Fix the logins with sp_change_users_login
-- Comes to you .Trn, you might have selected to append the Transaction log backup while scheduling the job
Shas3
July 25, 2003 at 2:12 pm
Thnaks for the info, Is there is Any problem if I have choosen Append teh transaction Option In my backup?. One more thing before restoring on new machine Should I have to create the User databases or restore will create by itself?. Can you Pl. also describe How to use sp_change_users_login. Thanks for your help.
July 25, 2003 at 2:26 pm
-- There is no problem with it, except the fact that it will keep getting bigger, until you re-initialize the file. I usually take log backup in to separate files and delete it after moving to the tape
-- You can create the database if you want to before restoring but you have to choose the option to restore over existing database, the best thing for you to do is specify the name of the database while restoring, it will create the database( Don’t forget to change the path here, the drive letters may not be the same on both servers)
-- After the restore go the QA and use sp_change_user_login @Action = ‘Report’ , it will show you list of the broken logins. You need fix those login. For more details pls refer to the Books online (search for sp_change_users_logn)
Shas3
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply