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 fe
w 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/pro...n/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 f
ew 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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment