Re: Multiple backup files
- From: wawork@xxxxxxxxxxx (Randy K)
- Date: Fri, 29 Dec 2006 16:34:44 GMT
Thanks Andrew I'll look into those products. I have a feeling that
compression on this data won't accomplish much. The raster data
imagery is compressed when loaded into the database by the GIS (ESRI)
software.
Randy
On Thu, 28 Dec 2006 20:13:45 -0500, "Andrew J. Kelly"
<sqlmvpnooospam@xxxxxxxxxxxx> wrote:
Yes you can by specifying multiple devices in your Backup command. They must
all be of the same type but can have different physical locations on disk.
But with something like that I would HIGHLY recommend using one of the 3rd
party tools to do compression and multiple files such as:
www.red-gate.com or www.quest.com
Your backups will be much smaller and take less time.
--
Andrew J. Kelly SQL MVP
"Randy K" <wawork@xxxxxxxxxxx> wrote in message
news:45946495.31744921@xxxxxxxxxxxxxxxxxxxxxxx
We have a aerial photo database that has grown to 1TB in size. The
backup file has out grown the space available. The hardware folks are
adding a new LUN but it is less than 1TB in size. But there is
additional space on another LUN. Is there a way to write the backup
to multiple destination files with size limitations?
BTW, this is SQL Server 2000
.
- References:
- Multiple backup files
- From: Randy K
- Re: Multiple backup files
- From: Andrew J. Kelly
- Multiple backup files
- Prev by Date: Re: Installation problems with Itanium based CDs
- Next by Date: Open default DB in Enterprise Manager upon connecting to server (SQL2000)
- Previous by thread: Re: Multiple backup files
- Next by thread: Re: Installation problems with Itanium based CDs
- Index(es):
Relevant Pages
|
