Archiving - 03-15-2005 , 09:38 PM
What's the best way to archive tables with binary data? Flat files/bcp/DTS
may not work if need to import binary data(not a fixed length column) with
quotes etc. What I am thinking is to export to another database and back it
up/archive on a regular basis. That way it will be easy to restore when
needed. Any other options?
Re: Archiving - 03-16-2005 , 08:18 AM
Why not just back up the database itself?
One thing you could do is put the tables w/ binary data on their own
filegroup -- then just back up that filegroup more regularly -- if that's
what you need?
SQL Server MVP
"Uhway" <vbhadharla (AT) sbcglobal (DOT) net> wrote