Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

moving system Databases Expand / Collapse
Author
Message
Posted Tuesday, October 23, 2007 10:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 31, 2007 9:11 AM
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
Post #414009
Posted Tuesday, October 23, 2007 10:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 31, 2007 9:11 AM
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
Post #414013
Posted Tuesday, October 23, 2007 9:17 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:40 PM
Points: 32,771, Visits: 14,934
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
Post #414157
Posted Wednesday, October 24, 2007 6:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 31, 2007 9:11 AM
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.
Post #414398
Posted Saturday, October 27, 2007 11:54 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, April 11, 2014 2:47 AM
Points: 416, Visits: 540
Refer the below link

Moving sys db's


Regards..Vidhya Sagar
SQL-Articles
Post #415766
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse