Groups | Blog | Home
all groups > sql server (alternate) > january 2004 >

sql server (alternate) : SQL DB move from one storage subsystem to another subsystem


max789 NO[at]SPAM yahoo.com
1/7/2004 7:33:41 PM
DB is 150GB and I cannot take it offline long enough to apply logs to a back up.
I am moving from one sub storage system to another.
Any mirroring ideas?
Greg D. Moore (Strider)
1/8/2004 4:39:25 AM

[quoted text, click to view]
back up.

Not sure what you mean.

Or rather, not clear on why you can't do a full backup, restore that with
NORECOVERY to your target system.
Perform a transaction log backup, NORECOVERY (this one will be relatively
large since the restore will probably take a long time).

Continue above step until your transaction backup is relatively small and
can be applied quickly (i.e. say under a minute) and simply do a transaction
backup on your source, apply it to your destination and then make it life.


[quoted text, click to view]

AddThis Social Bookmark Button