SEO

#1 (**permalink**) 02-28-2008, 07:26 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?
Thanks

#2 (**permalink**) 02-28-2008, 07:26 PM

"eudamon" <max789@yahoo.com> wrote in message
news:cf4ef727.0401071933.7ef4f84d@posting.google.c om...
> DB is 150GB and I cannot take it offline long enough to apply logs to a
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.

> I am moving from one sub storage system to another.
> Any mirroring ideas?
> Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

SQL DB move from one storage subsystem to another subsystem