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...
> > 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!
>
>