Moving DBs - SQL Server Forums

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)

Moving DBs

Author

Topic

Rupa
Posting Yak Master

123 Posts

Posted - 2008-07-07 : 07:39:44

Hey all

Hope all's well. I would like to move my SQL DBs to another server. I have two options:

1. Move it to a server that's on the existing domain.
2. Move it to a server that is not within the domain.

I haven't done this before so would like to know what your opinions are in terms of any security issues? My main concern is: If I move it to the one outside the domain, would I be able to access it from outside the domain?

Any other guidance will be highly appreciated!

Many thanks,

Rupa

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-07-07 : 07:54:19

If you are relying on Windows Authentication then this may be an issue , as far as your existing Windows Authentication users are involved.
If you have SQL Server Authentication - and you can access the server over the network , with correct ports etc , then you should be able to access

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-07 : 23:20:38

WIll work if domains are trusted.

Rupa
Posting Yak Master

123 Posts

Posted - 2008-07-08 : 06:00:36

Many thanks for that Jack and rmiao. Much appreciated. Meanwhile, if you think of any other issues I need to consider before the move, please do let me know.

Thanks,

Rupa

maninder
Posting Yak Master

100 Posts

Posted - 2008-07-08 : 15:20:42

considerations before moving:
copy all the database logins to new server:
check and correct for orphaned Logins:
update any linked servers for the Database.
Always use BAckup and Restore to move the File Over.
Before Restore check to see you have the same DRIVE configuration on the New Server.
Check Database DATA File PATH.
Then RESTORE with the WITH MOVE option.
RUN DBCC UPDATEusAGE and DBCC CHECKDB after the move.

Maninder
SQL server Architect / Admin (DEV&PROD)

Rupa
Posting Yak Master

123 Posts

Posted - 2008-08-20 : 05:32:10

Thank you Maninder..are there any issues I need to consider if the versions differ?

I am moving them from 2000 to SQL Server 2005?

Thanks,

Rupa

swekik
Posting Yak Master

126 Posts

Posted - 2008-08-20 : 17:46:18

After Restoring the databases you have to change the compatability level to 90

Rupa
Posting Yak Master

123 Posts

Posted - 2008-08-21 : 07:01:54

Thanks swekik, that's very useful.

Rupa