October 7, 2008 at 10:03 pm
i will need to migrate sql db from exiting location to new location.can any one tell me step by step process.i know the process but i want to know step by step clearly.because i need to migrate prod db.and in privious i never done it.
thanks alot
October 8, 2008 at 9:13 am
This Kb article lists the steps and options for moving databases: http://support.microsoft.com/kb/314546/en-us
I've most often used the backup/restore method, but I've also used detach/attach. Which one you use depends on your allowable downtime for the production databases.
Greg
October 10, 2008 at 12:25 am
i read the artical .it good help for me
can u tell me steps in migratin using bakup and restore.because i never performed this task,if u will send step by step then i will brave abt htis task because iam in project.no sr dba r available for me .it is on my shoulder.can pls tell 1 st what i do in source
and all those things .here for documents r not available.
October 10, 2008 at 1:10 am
you mean System Database or User Databases ?
October 10, 2008 at 9:00 am
Read the article I mentioned. It contains all the steps and information you need.
Greg
October 10, 2008 at 6:42 pm
Backup restore is the best bet.But make sure you have everything sorted out before you start to mitigate the downtime....
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
October 12, 2008 at 4:50 pm
yes crazy .i read the artical.how to i copy the backup file from server1 to server2.using roby copy.which parameters i will see before to start migration.
October 12, 2008 at 7:21 pm
You don't need to use robocopy. Copy the files manually.
October 12, 2008 at 10:51 pm
can u pls suggest me in the following steps.these the steps to follow in the migration of db using backup and restore
1.take the source db in single user mode and read only mode
2.take the backup of source db
3share the back up file and copy that file to new server
4 create new db in the new sever
5 restore the db from the backup to new server using following command
RESTORE DATABASE NewDBNAME FROM DISK = 'D:\xxxxxx\.BAK'
WITH MOVE 'old MDF LOGICAL FILENAME' TO 'F:\NEWPATH\NEWFILENAME.MDF',
MOVE 'old LDF LOGICAL FILENAME' TO 'E:\NEWPATH\NEWFILENAME.LDF',
RECOVERY
can u pls tell me it is correct ?
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply