use SSMS to relocate data/log files ?

#1

Sql Server 2005 : Can SSMS be reliably used to relocate data ( .mdf ) and
log ( .ldf ) files ?

#2

Personally, if you can afford downtime, I would prefer to detach the
database files, then move them manually, then use CREATE DATABASE ... FOR
ATTACH.

On 9/15/08 1:47 PM, in article uUnQds1FJHA.828 (AT) TK2MSFTNGP03 (DOT) phx.gbl, "John A
Grandy" <johnagrandy-at-gmail-dot-com> wrote:

Quote:

Sql Server 2005 : Can SSMS be reliably used to relocate data ( .mdf ) and
log ( .ldf ) files ?

#3

Personally, if you can afford downtime, I would prefer to detach the
database files, then move them manually, then use CREATE DATABASE ... FOR
ATTACH.

On 9/15/08 1:47 PM, in article uUnQds1FJHA.828 (AT) TK2MSFTNGP03 (DOT) phx.gbl, "John A
Grandy" <johnagrandy-at-gmail-dot-com> wrote:

Quote:

Sql Server 2005 : Can SSMS be reliably used to relocate data ( .mdf ) and
log ( .ldf ) files ?

#4

Personally, if you can afford downtime, I would prefer to detach the
database files, then move them manually, then use CREATE DATABASE ... FOR
ATTACH.

On 9/15/08 1:47 PM, in article uUnQds1FJHA.828 (AT) TK2MSFTNGP03 (DOT) phx.gbl, "John A
Grandy" <johnagrandy-at-gmail-dot-com> wrote:

Quote:

Sql Server 2005 : Can SSMS be reliably used to relocate data ( .mdf ) and
log ( .ldf ) files ?

#5

Personally, if you can afford downtime, I would prefer to detach the
database files, then move them manually, then use CREATE DATABASE ... FOR
ATTACH.

On 9/15/08 1:47 PM, in article uUnQds1FJHA.828 (AT) TK2MSFTNGP03 (DOT) phx.gbl, "John A
Grandy" <johnagrandy-at-gmail-dot-com> wrote:

Quote:

Sql Server 2005 : Can SSMS be reliably used to relocate data ( .mdf ) and
log ( .ldf ) files ?

#6

Personally, if you can afford downtime, I would prefer to detach the
database files, then move them manually, then use CREATE DATABASE ... FOR
ATTACH.

On 9/15/08 1:47 PM, in article uUnQds1FJHA.828 (AT) TK2MSFTNGP03 (DOT) phx.gbl, "John A
Grandy" <johnagrandy-at-gmail-dot-com> wrote:

Quote:

Sql Server 2005 : Can SSMS be reliably used to relocate data ( .mdf ) and
log ( .ldf ) files ?

#7

Personally, if you can afford downtime, I would prefer to detach the
database files, then move them manually, then use CREATE DATABASE ... FOR
ATTACH.

On 9/15/08 1:47 PM, in article uUnQds1FJHA.828 (AT) TK2MSFTNGP03 (DOT) phx.gbl, "John A
Grandy" <johnagrandy-at-gmail-dot-com> wrote:

Quote:

Sql Server 2005 : Can SSMS be reliably used to relocate data ( .mdf ) and
log ( .ldf ) files ?

#8

Personally, if you can afford downtime, I would prefer to detach the
database files, then move them manually, then use CREATE DATABASE ... FOR
ATTACH.

On 9/15/08 1:47 PM, in article uUnQds1FJHA.828 (AT) TK2MSFTNGP03 (DOT) phx.gbl, "John A
Grandy" <johnagrandy-at-gmail-dot-com> wrote:

Quote:

Sql Server 2005 : Can SSMS be reliably used to relocate data ( .mdf ) and
log ( .ldf ) files ?

#9

Personally, if you can afford downtime, I would prefer to detach the
database files, then move them manually, then use CREATE DATABASE ... FOR
ATTACH.

On 9/15/08 1:47 PM, in article uUnQds1FJHA.828 (AT) TK2MSFTNGP03 (DOT) phx.gbl, "John A
Grandy" <johnagrandy-at-gmail-dot-com> wrote:

Quote:

Sql Server 2005 : Can SSMS be reliably used to relocate data ( .mdf ) and
log ( .ldf ) files ?

#10

Personally, if you can afford downtime, I would prefer to detach the
database files, then move them manually, then use CREATE DATABASE ... FOR
ATTACH.

On 9/15/08 1:47 PM, in article uUnQds1FJHA.828 (AT) TK2MSFTNGP03 (DOT) phx.gbl, "John A
Grandy" <johnagrandy-at-gmail-dot-com> wrote:

Quote:

Sql Server 2005 : Can SSMS be reliably used to relocate data ( .mdf ) and
log ( .ldf ) files ?