Re: DTS
From: Rich (anonymous_at_discussions.microsoft.com)
Date: 10/02/04
- Previous message: Kenneth: "Re: Install of SQL Server 2000 will not allow any but (local) Server to Operate"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 2 Oct 2004 06:14:31 -0700
Thank you guys -
Appreciate the feedback.
Rich
>-----Original Message-----
>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: Kenneth: "Re: Install of SQL Server 2000 will not allow any but (local) Server to Operate"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
