 | |
Is this a possible scenario
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Is this a possible scenario -
08-19-2005
, 05:20 AM
#2
| |||
| |||
|
|
Server 1 Production Server 2 Test a) detach files on server 1 b) copy files from server 1 to 2 c) attach files on server 1 and 2 /Michael V. |
#3
| |||
| |||
|
|
A scenario for what? If you want to take a copy of a production DB to Test and production can stand to be down whilst you copy the files then yes this will work. It will not achieve more than a BACKUP and RESTORE though and this is an Online operation Allan "Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote in message news:OvMwaeKpFHA.3084 (AT) TK2MSFTNGP09 (DOT) phx.gbl... Server 1 Production Server 2 Test a) detach files on server 1 b) copy files from server 1 to 2 c) attach files on server 1 and 2 /Michael V. |
#4
| |||
| |||
|
|
Thankx allan So what you're saying is that I can achieve the same using backup and restore and then without detaching.... "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:O9jPwyQpFHA.1444 (AT) tk2msftngp13 (DOT) phx.gbl... A scenario for what? If you want to take a copy of a production DB to Test and production can stand to be down whilst you copy the files then yes this will work. It will not achieve more than a BACKUP and RESTORE though and this is an Online operation Allan "Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote in message news:OvMwaeKpFHA.3084 (AT) TK2MSFTNGP09 (DOT) phx.gbl... Server 1 Production Server 2 Test a) detach files on server 1 b) copy files from server 1 to 2 c) attach files on server 1 and 2 /Michael V. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.