|
Home > Archive > MS SQL Server > March 2006 > SQL question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| Experts,
SQL question here. When you shut down a database gracefully, in order to
copy it to a new location, do you need to copy that database's corresponding
log file as well?
--
Spin
| |
|
|
| Uri Dimant 2006-03-05, 8:24 pm |
| Spin
I'd prefer RESTORE DATABASE ....WITH MOVE option
For more details please refer to the BOL
"Spin" <Spin@spin.com> wrote in message
news:46vgp1Fd70ubU1@
individual.net...
> Experts,
>
> SQL question here. When you shut down a database gracefully, in order to
> copy it to a new location, do you need to copy that database's
> corresponding log file as well?
>
> --
> Spin
>
>
| |
| Sreejith G 2006-03-05, 8:24 pm |
| Yes you need to copy the log file...
Whats the size of your DB... If its huge size better detach and attach DB.
--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"Spin" wrote:
> Experts,
>
> SQL question here. When you shut down a database gracefully, in order to
> copy it to a new location, do you need to copy that database's corresponding
> log file as well?
>
> --
> Spin
>
>
>
|
|
|
|
|