PLease I need help on how to move a sql database from one
machine to another. We just bought a new server that is
fast and reliable, I just need help in migrating the

[quoted text, click to view]

The best technique would be a database BACKUP from the source server and a
RESTORE on your target server. See Books Online for the proper syntax.

Steve

Backing up from the source to the destination could be the best way, how
abut hostname/computer name. Will i name the new server the same name as
the old?, What kind of back up software will i use. Will Sql back up
work?

Thanks a lot


*** Sent via Developersdex http://www.developersdex.com ***

[quoted text, click to view]
The new server does not have to have the same name as the old server.

I was speaking of the TSQL BACKUP & TSQL RESTORE that are built into the
base SQL Server product, SQL Server books online has the syntax. Two ways,
you could run BACKUP to the local source server, then copy it to your target
server and RESTORE it there
- or -
run a BACKUP using a UNC on the target server (like \\newserver\share )
then run the RESTORE. Note for the UNC to work your MSSQLServer account will
need to run under a domain account that has write permissions at the target
server UNC.

Steve

You could also try detaching the database on the old server and attaching it
to the new server (using sp_detach_db and sp_attach_db). You can find more
info about these system stored procs in books online.

--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example


[quoted text, click to view]

Try this link:
http://www.support.microsoft.com/?id=314546




[quoted text, click to view]