Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


moving system Databases


moving system Databases

Author
Message
sqldba_ind
sqldba_ind
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 32
Hi all

I went throught some articles those was saying about only attach/Deatach.

so that I posted this Questions.
We have a plan to move SQL Server from Old server ot New Server.
for above we prepared a check list.

Here I have couple of Douts
1.Can I take Backup of master.msdb database and Restore in Destination Server.If I follow above what are the Scenario can I follow.

Please let me know which is the best scenario Backup/restore or attach deatch

2.If I move Master and MSDB is it neccessary to move again JOB,ALERT,OPERATOR also or those will come with MSDB Restoration.

3.According above scenario what I have to about DTS,still shall I Export/Import DTS or Opening and saving in Text file and moving in to destination Server

Please some body help on this issue,
I greatefull to you all
sqldba_ind
sqldba_ind
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 32
I am Trying to Up load my Document,but I did not find any upload option so that I copy pasted Checklist what prepared.

Check list moving Databases between the Servers.
* DS Destination Server,
* SS Source Server.

S.NO Task
1.Verify the SS and DS Servers OS versions, Version of DS must to be match or Must be higher level Version then SS

2.Verify the SS and DS Servers SP Versions, Version of DS must to be match equal or Must be higher level Version then SS.

3.Verify the SS and DS Servers SQL Server versions, Version of the DS must to be match equal
4.Verify the SS and DS for SQL Server 2000 SP versions, SP Version of the DS must to be match or Higher then SS.

5.Make and Verify a Networking shared drive which is accessible from both DS and SS and allocate sufficient space in Network Drive.

6.Verify the Space in DS and Storage Space should higher then SS

7.Move the master database Data file, Log file and Store in Network Drive.

8.Move the master database Data file, Log file and Store in Network Drive.

**9.Attach the Master database in SS
**10.Attach the MSDB database in SS
11.Move the alert ,Jobs, alert and Operator to SS
**12.Move the DTS packages from DS to SS using DTS Export.
13.Move all Scripts.

14.Backup User Databases and Store in Network Drive,
15.Restore UDB’s in to SS

16. Verify the Logins

** 9 & 10. Moving master, msdb Database is some how Critical Job, It is better to move data files and Log files using Detach and Attach method.

** 12. Move the all DTS Package to DS, but make sure that the path must same with SS
Steve Jones
Steve Jones
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: Administrators
Points: 40540 Visits: 18846
http://www.sqlservercentral.com/articles/Administering/movingmsdb/854/
http://www.sqlservercentral.com/articles/Administering/moveyourmaster/847/

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
sqldba_ind
sqldba_ind
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 32
Hi all

Right now our plan got changed and we are planning to move only UDB's

This is the action plan I perpared for Moving Databases between the servers,

Action Plan:

1. Change all Source Server Databases Database Recovery Modes in Full and
Set Transaction Log backup(What ever flexible timing)



2. Take full Backup all Databases and Restore in to destination Server WITH RECOVERY


3. Move the ALERTS,JOBS,OPERATORS


4. Move the DTS packages


5. Make Sure that every Database is Moved



6. Fix Login in Destination Server(Orphan Users).
(what every application using /Database using)




7. Again Backup all Databases and Restore in to destination Server. WITH NORECOVERY


8. Apply the Transactional Backup’s WITH NORECOVERY Up to Databases server are in Sync


9. Once Databases are in Sync Apply last transactional backup WITH RECOVERY

Please give you suggestion.what every you feel.
vidhya sagar
vidhya sagar
SSC-Addicted
SSC-Addicted (464 reputation)SSC-Addicted (464 reputation)SSC-Addicted (464 reputation)SSC-Addicted (464 reputation)SSC-Addicted (464 reputation)SSC-Addicted (464 reputation)SSC-Addicted (464 reputation)SSC-Addicted (464 reputation)

Group: General Forum Members
Points: 464 Visits: 620
Refer the below link

Moving sys db's

Regards..Vidhya Sagar
SQL-Articles
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search