Moving SQL Database to a new server

I am moving a sql database from a windows 2000 server to a new windows 2003
server. I read where there is 3 ways to do this: ? Backup and Restore
? Sp_detach_db and Sp_attach_db stored procedures
? Import and Export Data (to copy objects and data between SQL Server
databases)
My question is after reading the descriptions on these I still don't know if
I should do a backup and restore or a import and export. There will not be
anyone using the database when I will be working on it. Any suggestions?
Thanks!
If it's a small db, just one data file and one log file, just detach and
re-attach. Otherwise,
I'd perform a backup and restore.
Remember to re-apply any database logins, roles, and users
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:0FC783C5-0C29-4ED2-996E-3F86F6A47C55@.microsoft.com...
> I am moving a sql database from a windows 2000 server to a new windows
2003
> server. I read where there is 3 ways to do this: . Backup and Restore
> . Sp_detach_db and Sp_attach_db stored procedures
> . Import and Export Data (to copy objects and data between SQL Server
> databases)
> My question is after reading the descriptions on these I still don't know
if
> I should do a backup and restore or a import and export. There will not
be
> anyone using the database when I will be working on it. Any suggestions?
> Thanks!
|||Keep in mind the following:
1. You also have to transfer your logins from the source server to the dest.
server
2. Your jobs
3. Your custom error msg (if any) reside on system database
Sasan Saidi, MSc in CS
Senior DBA
Brascan Business Services
"I saw it work in a cartoon once so I am pretty sure I can do it."
"Armando Prato" wrote:

> If it's a small db, just one data file and one log file, just detach and
> re-attach. Otherwise,
> I'd perform a backup and restore.
> Remember to re-apply any database logins, roles, and users
>
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:0FC783C5-0C29-4ED2-996E-3F86F6A47C55@.microsoft.com...
> 2003
> if
> be
>
>