How to migrate data from a server to a new machine

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

How to migrate data from a server to a new machine

Author

Topic

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2007-02-19 : 14:11:08

Hi to all,

I m a new DBA
I have a problem
I have a SQL Server with 300 Databases on a machine.
Now company has bought new Machine
How to migrate data from old server to this new machine
without recreating logins
can some one help

Thanks in advance

Kristen
Test

22859 Posts

Posted - 2007-02-19 : 17:04:44

With no disrespect to your good self:

WTF are companies doing putting an untrained person in charge of 300 databases and expecting that "trainee" to be able to manage the databases in, presumably, a mission-critical manner by only giving him/her access to Google?

I give up

Kristen

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-19 : 19:21:46

take a look at http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210 under Backup / Restore / Replication / Jobs / Houskeeping

abundant_lyfe
Starting Member

10 Posts

Posted - 2007-02-20 : 10:55:05

quote:
Originally posted by rajkumarrai_bis

Hi to all,

I m a new DBA
I have a problem
I have a SQL Server with 300 Databases on a machine.
Now company has bought new Machine
How to migrate data from old server to this new machine
without recreating logins
can some one help

Thanks in advance

He's not alone! My company have just asked me to create a new SQL database to deal with vast amounts of info and change the way we deal with some of our data.

The only experience I have of SQL is some very basic queries! Good think I'm a quick learner.

Kristen
Test

22859 Posts

Posted - 2007-02-21 : 02:43:15

"Good think I'm a quick learner."

Problem is that it takes experience, and usually training, to be able to set up a safe environment to ensure that a database is secure.

You can learn from your mistakes, of course, but that may involve losing data along the way, or long periods of service outages - which may not be very good for your company's PR!

My view remains the same. Companies that just get an inexperienced person to look after mission critical data is nuts.

Why don't they get a consultant in for a few hours to set stuff up, you can look over their shoulder, and if you ask some sharp questions you, and your company, will be miles ahead of where you are now.

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources