I need to migrate an application from one server to another.
I have always in the past detached the db and re-attached to the new
server.
Was are the pros and cons from doing it this way?
Should I be restoring the db on the new server from a backup?
Which is the preferred way in which to do a migration?
thanks,
kim
Kim,
you can do the detach and reattach but this can be messy if you are
using more than one file group. The method of using backup and restore
is faster the only thing you need to remember is you have to be in
single user mode to restore the db to the new server. Als you will need
to have a storage disk accessible from both servers to do the backup
Bill
*** Sent via Developersdex http://www.codecomments.com ***
|||I have everything on one file group - so no concern there.
thank you for the reply.
"Bill" <nospam@.devdex.com> wrote in message
news:eqCs1Zu8GHA.2364@.TK2MSFTNGP02.phx.gbl...
> Kim,
> you can do the detach and reattach but this can be messy if you are
> using more than one file group. The method of using backup and restore
> is faster the only thing you need to remember is you have to be in
> single user mode to restore the db to the new server. Als you will need
> to have a storage disk accessible from both servers to do the backup
>
> Bill
> *** Sent via Developersdex http://www.codecomments.com ***
|||Kim wrote:
> I have everything on one file group - so no concern there.
> thank you for the reply.
>
Detach and attach is fine if you don't mind taking the database
offline. The main advantage of a backup is that your database can still
be used.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
|||Hi,
There is no disadvantage in using Detach and Attach; apart from the reason
it needs a down time. Where as if you use Backup and Restore
it do not require a downtime.
Thanks
Hari
"Kim" <kim@.xxx.com> wrote in message
news:qruZg.15868$nn6.1113@.bignews6.bellsouth.net.. .
>I need to migrate an application from one server to another.
> I have always in the past detached the db and re-attached to the new
> server.
> Was are the pros and cons from doing it this way?
> Should I be restoring the db on the new server from a backup?
> Which is the preferred way in which to do a migration?
> thanks,
> kim
>
|||I will used backup fullbackup and restore with norecovery,
And restore transaction with recovery
It will reduce downtime.
Cheers
"Kim" wrote:
> I need to migrate an application from one server to another.
> I have always in the past detached the db and re-attached to the new
> server.
> Was are the pros and cons from doing it this way?
> Should I be restoring the db on the new server from a backup?
> Which is the preferred way in which to do a migration?
> thanks,
> kim
>
>
|||> Detach and attach is fine if you don't mind taking the database
> offline. The main advantage of a backup is that your database can still
> be used.
And that you have **at least one** complete backup!
No comments:
Post a Comment