Help: Moving SQL Database to another machine

Hi All
I will like to get some pointers on moving a SQL database to another machine. I know that I have a couple of options such as: backup and restore, Sp_detach_db and Sp_attach_db, and import adn export. I was wondering which is the best option keeping a few things in mind
1) Need to keep the old SQL Server as i
2) Reduce data loss to the mimimu
3) The simpliest and most straight-forward option as I am kind of new to SQL Serve
Also, I will like to know where I can find some good documentation on managing SQL Servers
Thanks in advance
Dee.HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546&Product=sql2k
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Bond_007" <anonymous@.discussions.microsoft.com> wrote in message
news:A78A0D05-51C5-465A-BD14-74C9F8EE8F0A@.microsoft.com...
> Hi All,
> I will like to get some pointers on moving a SQL database to another
machine. I know that I have a couple of options such as: backup and
restore, Sp_detach_db and Sp_attach_db, and import adn export. I was
wondering which is the best option keeping a few things in mind.
> 1) Need to keep the old SQL Server as is
> 2) Reduce data loss to the mimimum
> 3) The simpliest and most straight-forward option as I am kind of new to
SQL Server
> Also, I will like to know where I can find some good documentation on
managing SQL Servers.
> Thanks in advance,
> Dee.|||You can find the steps for moving databases to another
server in the following articles:
INF: Moving SQL Server databases to a new location with
Detach/Attach
http://support.microsoft.com/?id=224071
INF: Moving SQL Server 7.0 Databases to a New Server with
BACKUP and RESTORE
http://support.microsoft.com/?id=304692
For documentation on managing servers, books online is a
good resource. In addition, you may want to go through the
Operations Guide:
http://www.microsoft.com/TechNet/prodtechnol/sql/2000/maintain/sqlops0.mspx
-Sue
On Wed, 19 May 2004 12:21:05 -0700, "Bond_007"
<anonymous@.discussions.microsoft.com> wrote:
>Hi All,
>I will like to get some pointers on moving a SQL database to another machine. I know that I have a couple of options such as: backup and restore, Sp_detach_db and Sp_attach_db, and import adn export. I was wondering which is the best option keeping a few things in mind.
>1) Need to keep the old SQL Server as is
>2) Reduce data loss to the mimimum
>3) The simpliest and most straight-forward option as I am kind of new to SQL Server
>Also, I will like to know where I can find some good documentation on managing SQL Servers.
>Thanks in advance,
>Dee.