Re: DTS
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 09/30/04
- Previous message: Rich: "DTS"
- In reply to: Rich: "DTS"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 29 Sep 2004 21:58:13 -0500
Hi,
There are 2 options:-
1. Perform a backup, copy the file to destination server and Restore the
database (no downtime)
2. Detach the database, copy MDF and LDF to destination, attach the database
I. Backup and Restore
1. Backup the database from OSQL from command prompt.
c:\> OSQL -Usa -Ppassword -Sserver_name (enter)
1>backup database dbname to disk='c:\backup\dbanme.bak' with init
2>go
THis will backup the database to c:\backup folder
2. COpy the dbname.bak to destination server
3. Restore the database using (RESTORE Database command) from OSQL
II. Detach / Attach
1. detach the database from source server
c:\> OSQL -Usa -Ppassword -Sserver_name (enter)
1>sp_detach_db <dbname>
2>go
2. copy the MDF and LDF to destination server
3. Attach the database in source server (Use SP_ATTACH_DB procedure - refer
books online)
4.Attach the database in destination server (Use SP_ATTACH_DB procedure -
refer books online)
-- Thanks Hari MCDBA "Rich" <anonymous@discussions.microsoft.com> wrote in message news:406101c4a692$53cfa650$a501280a@phx.gbl... > Hi, > We have SQL2000 running on a 2000 Server. We wanted to > copy the datafiles to our SBS2003 server. I created a > DTS import package but would now like to modify it. > Unfortunately, I can't find it. Where can I find the > package? > > Thanks > Rich
- Previous message: Rich: "DTS"
- In reply to: Rich: "DTS"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
