March 31, 2010 at 12:12 pm
Hello,
please send me step by step process to move one DB(including system DBs) from sql 2005 to sql 2005 but to a different server.
my worry is that : -
1 - how backup and other jobs (scheduled/unscheduled) would move?
2 - how DTS packages would move?
3 - how SSIS packages would move?
4 - how logins would move?
5 - how alerts would move?
6 - how operators would move?
7 - how server objects like backup devices, endpoints, linked servers and triggers would move?
8 - how replication (publication/subscription) info would move?
9 - how maintenance plans would move?
10 -how to get old sql server logs and error logs in the new server?
appreciate an early response on it. Many Thanks.
Rgds,
Pankaj
March 31, 2010 at 12:16 pm
May I suggest that you start by reading Books Online. Some of the items you can script, others, depending on how stored, by moving files, some may have to be reconfigured on the new server.
March 31, 2010 at 12:21 pm
Hi,
can you please put your reply question by question saying this needs to be scripted and this needs to be reconfigured...etc.. thanks...
Rgds,
Pankaj
March 31, 2010 at 12:36 pm
[ soap box ]
Sorry, but unless you are willing to pay me to write you your step by step instructions to do your job, no. Try reading BOL and see what you need to do to complete your required tasks. If you have specific questions about a specific topic, then ask that question and we will be more than willing to help you understand that piece.
[ /soap box ]
March 31, 2010 at 12:52 pm
pankaj.baluni (3/31/2010)
Hello,please send me step by step process to move one DB(including system DBs) from sql 2005 to sql 2005 but to a different server.
my worry is that : -
1 - how backup and other jobs (scheduled/unscheduled) would move?
2 - how DTS packages would move?
3 - how SSIS packages would move?
4 - how logins would move?
5 - how alerts would move?
6 - how operators would move?
7 - how server objects like backup devices, endpoints, linked servers and triggers would move?
8 - how replication (publication/subscription) info would move?
9 - how maintenance plans would move?
10 -how to get old sql server logs and error logs in the new server?
appreciate an early response on it. Many Thanks.
What have you done here to find out the answers to these questions?
I think you will get a lot more information by taking the time to separate the questions out one by one and researching the issues.
You will get more weight here in the forum if you separate the questions and elaborate upon each one what you mean.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 31, 2010 at 1:02 pm
I'll help. You can't do #2 because DTS doesn't run really run on 2005 servers (yes, you can run it from SSIS or you can do a custom install of the DTS engine, but you really, really shouldn't). All the rest can be scripted.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 31, 2010 at 1:03 pm
pankaj.baluni (3/31/2010)
Hi,can you please put your reply question by question saying this needs to be scripted and this needs to be reconfigured...etc.. thanks...
Heh. I have to admire your cheek. 😀
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 31, 2010 at 2:28 pm
For #2. Wouldn't they get restored as part of MSDB database restore ?
March 31, 2010 at 2:40 pm
homebrew01 (3/31/2010)
For #2. Wouldn't they get restored as part of MSDB database restore ?
Not always.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 31, 2010 at 2:43 pm
homebrew01 (3/31/2010)
For #2. Wouldn't they get restored as part of MSDB database restore ?
It depends - stored in msdb or on filesystem.
Same with #3
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 31, 2010 at 7:55 pm
It depends
Steve!! Sue him for copyright violation!!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 1, 2010 at 6:25 am
I don't understand your question fully.
You ask how to move one database, but you include the system databases in that question. That's automatically more than one database.
You can move all of these things very easily if you want to move EVERYTHING from one server to another. Move all the storage (whether that's local drives, a SAN, or something else) to the new server. Include the system volumes, and boot, etc., off the same drive and partition that the old server booted from. That will move everything from one server to the other.
I'm assuming that's not a solution for you, or you wouldn't be asking all the details.
Honestly, the answer to every one of your questions is, "hire someone who knows how to do this and pay them to do it". If you want to learn the process yourself, then I recommend setting up two computers, possibly VMs on your desktop. Create databases on one, and then read the relevant sections of BOL. Then you can practice moving the databases from one computer (or VM) to the other. Once you can do that easily and perfectly every time, then you can try it on a real server.
It's not something you'll learn correctly from reading a few posts on an online forum. You'll need to do some serious reading, and you'll need to practice. Expect to take a few weeks (at least) to really learn the subject.
But, if you have a server that you need to move on a more immediate basis, hire someone who has a proven track record of doing that. It'll be the best way to get it done.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 1, 2010 at 8:50 am
Yes, that is exactly what is was looking for.... and also many thanks for your suggestion that i would for sure... 🙂
Many Thanks.
Rgds,
Pankaj
April 1, 2010 at 10:57 am
You're welcome
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply