I need to divide a 5 GB database into two parts so that
it does reach the 4 GB to winzip a file.
Please help me with this task.
Thank You,
DeanYou can backup a DB to multiple backup files. This is normally done for
striping backup of large DB's (and 4G isn't one...) across multiple disks,
but it will certainly meet your need.
Simply use the SQL Enterprise Manager backup GUI and put two files in the
list instead of one...
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Dean" <anonymous@.discussions.microsoft.com> wrote in message
news:043d01c3db04$1f9dc010$a501280a@.phx.gbl...
> I need to divide a 5 GB database into two parts so that
> it does reach the 4 GB to winzip a file.
> Please help me with this task.
> Thank You,
> Dean|||To add to Brian's response, you can use SqlLitespeed
<http://www.dbassociatesit.com/products.asp?prod=1> to compress during the
backup. This reduces both time and space and doesn't have the 4GB size
limit.
Hope this helps.
Dan Guzman
SQL Server MVP
"Dean" <anonymous@.discussions.microsoft.com> wrote in message
news:043d01c3db04$1f9dc010$a501280a@.phx.gbl...
> I need to divide a 5 GB database into two parts so that
> it does reach the 4 GB to winzip a file.
> Please help me with this task.
> Thank You,
> Dean|||Dan,
I second that motion.
SQLLiteSpeed ROCKS!
But, it does beg the question - why can't MS do it?
James Hokes
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:O%234CLTx2DHA.2888@.tk2msftngp13.phx.gbl...
> To add to Brian's response, you can use SqlLitespeed
> <http://www.dbassociatesit.com/products.asp?prod=1> to compress during the
> backup. This reduces both time and space and doesn't have the 4GB size
> limit.
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Dean" <anonymous@.discussions.microsoft.com> wrote in message
> news:043d01c3db04$1f9dc010$a501280a@.phx.gbl...
> >
> > I need to divide a 5 GB database into two parts so that
> > it does reach the 4 GB to winzip a file.
> >
> > Please help me with this task.
> >
> > Thank You,
> >
> > Dean
>|||> But, it does beg the question - why can't MS do it?
Send your product enhancements requests to sqlwish@.microsoft.com.
I guess it's mostly a matter of prioritizing features based on development
resources. We'd never see a new version if they tried to squeeze everything
into the next release.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"James Hokes" <noemail@.noway.com> wrote in message
news:OJ6tMNy2DHA.556@.TK2MSFTNGP11.phx.gbl...
> Dan,
> I second that motion.
> SQLLiteSpeed ROCKS!
> But, it does beg the question - why can't MS do it?
> James Hokes
> "Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
> news:O%234CLTx2DHA.2888@.tk2msftngp13.phx.gbl...
> > To add to Brian's response, you can use SqlLitespeed
> > <http://www.dbassociatesit.com/products.asp?prod=1> to compress during
the
> > backup. This reduces both time and space and doesn't have the 4GB size
> > limit.
> >
> >
> > --
> > Hope this helps.
> >
> > Dan Guzman
> > SQL Server MVP
> >
> > "Dean" <anonymous@.discussions.microsoft.com> wrote in message
> > news:043d01c3db04$1f9dc010$a501280a@.phx.gbl...
> > >
> > > I need to divide a 5 GB database into two parts so that
> > > it does reach the 4 GB to winzip a file.
> > >
> > > Please help me with this task.
> > >
> > > Thank You,
> > >
> > > Dean
> >
> >
>|||Third-party vendors need to eat, too!
I third the motion -- SQLLiteSpeed has benefited me in a tremendous way.
I'm currently working with DBAssociates on a case study of our deployment...
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:%23Y5WEjy2DHA.1720@.TK2MSFTNGP10.phx.gbl...
> > But, it does beg the question - why can't MS do it?
> Send your product enhancements requests to sqlwish@.microsoft.com.
> I guess it's mostly a matter of prioritizing features based on development
> resources. We'd never see a new version if they tried to squeeze
everything
> into the next release.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "James Hokes" <noemail@.noway.com> wrote in message
> news:OJ6tMNy2DHA.556@.TK2MSFTNGP11.phx.gbl...
> > Dan,
> >
> > I second that motion.
> > SQLLiteSpeed ROCKS!
> >
> > But, it does beg the question - why can't MS do it?
> >
> > James Hokes
> >
> > "Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
> > news:O%234CLTx2DHA.2888@.tk2msftngp13.phx.gbl...
> > > To add to Brian's response, you can use SqlLitespeed
> > > <http://www.dbassociatesit.com/products.asp?prod=1> to compress during
> the
> > > backup. This reduces both time and space and doesn't have the 4GB
size
> > > limit.
> > >
> > >
> > > --
> > > Hope this helps.
> > >
> > > Dan Guzman
> > > SQL Server MVP
> > >
> > > "Dean" <anonymous@.discussions.microsoft.com> wrote in message
> > > news:043d01c3db04$1f9dc010$a501280a@.phx.gbl...
> > > >
> > > > I need to divide a 5 GB database into two parts so that
> > > > it does reach the 4 GB to winzip a file.
> > > >
> > > > Please help me with this task.
> > > >
> > > > Thank You,
> > > >
> > > > Dean
> > >
> > >
> >
> >
>
