MS SQL Server - Copy database to another server

Author

Copy database to another server

David Thielen

2006-02-15, 8:23 pm

Hi;

I asked this once before but can't find the info now. I need to copy a
database from one server and put it on a second server. It is Sql Server 2000
and both servers are running Windows 2003 in a workgroup (not a domain).

I want to get all of the data and meta-data across. How can I do this? (All
I remember is it is very complex because the systems are not in a domain.)

--
thanks - dave
david_at_windward_do
t_net
http://www.windwardreports.com

Tibor Karaszi

2006-02-16, 3:23 am

Have a look at this list compiled by Andrew Kelly:

Moving DB's between Servers
http://www.support.microsoft.com/?id=314546

Moving SQL Server Databases to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=224071

Using WITH MOVE in a Restore
http://support.microsoft.com/?id=221465

How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133

Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897

Utility to map logins to users
http://www.dbmaint.com/SyncSql Logins.asp

User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001

How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872

Restoring a .mdf
http://www.sqlservercentral.com/scr...sp?scriptid=599

Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/

"David Thielen" <david@bogus.windward.net> wrote in message
news:C8DE23AA-9CF6-46E8-8358- A998B00470EA@microso
ft.com...
> Hi;
>
> I asked this once before but can't find the info now. I need to copy a
> database from one server and put it on a second server. It is Sql Server 2000
> and both servers are running Windows 2003 in a workgroup (not a domain).
>
> I want to get all of the data and meta-data across. How can I do this? (All
> I remember is it is very complex because the systems are not in a domain.)
>
> --
> thanks - dave
> david_at_windward_do
t_net
> http://www.windwardreports.com
>

David Thielen

2006-02-17, 7:23 am

Hi;

The post http://www.support.microsoft.com/kb/304692/ is for Sql Server 7
only. Is there a post somewhere for Sql Server 2000?

--
thanks - dave
david_at_windward_do
t_net
http://www.windwardreports.com

David Thielen

2006-02-17, 7:23 am

Also, this post says how to restore a database - but not how to back it up.
How do I back it up?

--
thanks - dave
david_at_windward_do
t_net
http://www.windwardreports.com

"David Thielen" wrote:

> Hi;
>
> The post http://www.support.microsoft.com/kb/304692/ is for Sql Server 7
> only. Is there a post somewhere for Sql Server 2000?
>
> --
> thanks - dave
> david_at_windward_do
t_net
> http://www.windwardreports.com
>

Tibor Karaszi

2006-02-17, 7:23 am

A quick look suggests that this should also work for 2000, but test in a test environment first. As
for how to backup, read in Books Online about the BACKUP DATABASE command.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/

"David Thielen" <david@bogus.windward.net> wrote in message
news:949DC479-E52A-44BE-970F- AB64E05459AD@microso
ft.com...[color=darkred]
> Also, this post says how to restore a database - but not how to back it up.
> How do I back it up?
>
> --
> thanks - dave
> david_at_windward_do
t_net
> http://www.windwardreports.com
>
>
>
> "David Thielen" wrote:
>

Sponsored Links