Transferring a sql server database to another server

19 May 2005 5:36 PM

Jack

Hi,
I need to transfer a sql server database from a NT based sql server to a
Windows 2003 based sql server. I was just wondering, what is the best way to
go about doing this. Any suggestion, articles is helpful. Thanks in advance.

19 May 2005 6:05 PM

Narayana Vyas Kondreddi

Try backup and restore. See BACKUP and RESTORE commands in SQL Server Books
Online.

--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/

Show quoteHide quote

"Jack" <J***@discussions.microsoft.com> wrote in message
news:EF4FCA89-0489-4F36-A6F0-30882461B2DF@microsoft.com...
> Hi,
> I need to transfer a sql server database from a NT based sql server to a
> Windows 2003 based sql server. I was just wondering, what is the best way
to
> go about doing this. Any suggestion, articles is helpful. Thanks in
advance.

19 May 2005 6:07 PM

Andrew J. Kelly

Have a look at these:

http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/features/mssql/article.php/3379901    Moving
system DB's
http://www.support.microsoft.com/?id=314546     Moving DB's between Servers
http://www.support.microsoft.com/?id=224071     Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465             Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133     How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897    Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp         Utility to map logins to
users
http://www.support.microsoft.com/?id=168001     User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872    How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers

--
Andrew J. Kelly SQL MVP

Show quoteHide quote

"Jack" <J***@discussions.microsoft.com> wrote in message
news:EF4FCA89-0489-4F36-A6F0-30882461B2DF@microsoft.com...
> Hi,
> I need to transfer a sql server database from a NT based sql server to a
> Windows 2003 based sql server. I was just wondering, what is the best way
> to
> go about doing this. Any suggestion, articles is helpful. Thanks in
> advance.

19 May 2005 6:34 PM

Jack

Thanks Andrew and Narayana for the help. Regards

Show quoteHide quote

"Andrew J. Kelly" wrote:

> Have a look at these:
>
>
> http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
> http://www.databasejournal.com/features/mssql/article.php/3379901    Moving
> system DB's
> http://www.support.microsoft.com/?id=314546     Moving DB's between Servers
> http://www.support.microsoft.com/?id=224071     Moving SQL Server Databases
> to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465             Using WITH MOVE in a
> Restore
> http://www.support.microsoft.com/?id=246133     How To Transfer Logins and
> Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=298897    Mapping Logins & SIDs after a
> Restore
> http://www.dbmaint.com/SyncSqlLogins.asp         Utility to map logins to
> users
> http://www.support.microsoft.com/?id=168001     User Logon and/or Permission
> Errors After Restoring Dump
> http://www.support.microsoft.com/?id=240872    How to Resolve Permission
> Issues When a Database Is Moved Between SQL Servers
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Jack" <J***@discussions.microsoft.com> wrote in message
> news:EF4FCA89-0489-4F36-A6F0-30882461B2DF@microsoft.com...
> > Hi,
> > I need to transfer a sql server database from a NT based sql server to a
> > Windows 2003 based sql server. I was just wondering, what is the best way
> > to
> > go about doing this. Any suggestion, articles is helpful. Thanks in
> > advance.
>
>
>