The actual limitation is that any one file WITHIN the .cab file may not
exceed 2Gb. I have successfully archived a 6Gb database before, but we
have another 22Gb that will not archive.
Adrian Cox wrote...
> When the database is over 2Gb msmdarch will keep generating additional cab
> files until it has archived the whole database (eg data.cab, data.cab2,
> data.cab3 etc).
> To restore you just select the first cab file in the set.
> Hope this helps
> Adrian Cox
> > this is true, a .cab file doesn't allow to store a file size greater than
> > 2GB. we are looking for the answer as well and hope someone here would
> > a better idea. please let us know if you can find something.
> > > Hi,
> > > Someone can tell me if there is a limitation for archiving
> > > database using the msmdarch.exe?
> > > I ask this because a hear somebody tell that there is a
> > > limitation of 2GB archiving database with msmdarch,
> > > because the limitation of files .cab are 2gb.
> > > Is this correct?
> > > Rgds.
> > > Martini
> > > DBA SQL Server
> > > Procergs - RS - Brasil
Darren Gosbell MCSD MCP
Datum Group (http://www.datum.com.au)