hot backup

any good Hot Backup tools recommend ?
thx!
Ken wrote:
> any good Hot Backup tools recommend ?
> thx!
LiteSpeed would be my recommendation, although I am biased a bit. See
our web site for industry reviews and more information. A free trial is
available.
David Gugick
Imceda Software
www.imceda.com
|||I will second David's recommendations.
Andrew J. Kelly SQL MVP
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:eVg9MapGFHA.3076@.tk2msftngp13.phx.gbl...
> Ken wrote:
> LiteSpeed would be my recommendation, although I am biased a bit. See our
> web site for industry reviews and more information. A free trial is
> available.
> --
> David Gugick
> Imceda Software
> www.imceda.com
|||If you don't want to purchase any software just use the Transact-SQL BACKUP
command
BACKUP DATABASE master TO DISK = 'c:\master.bak' WITH INIT
...repeat for msdb and your user databases
Make sure that you read up on BACKUP and RESTORE within Books Online (within
the SQL Server program group).
Keith
"Ken" <kentsang77@.yahoo.com> wrote in message
news:OH%23FJuoGFHA.3088@.tk2msftngp13.phx.gbl...
> any good Hot Backup tools recommend ?
> thx!
>
|||What are some ballpark costs? I really don't want to get into the situation
of being dunned by a vendor when all I want to do is try it out *after* I
find out whether we can afford it. I'm looking at a single
SQL server with a database under 5GB...
Regards,
Hank Arnold
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23sf6$rpGFHA.3628@.TK2MSFTNGP15.phx.gbl...
>I will second David's recommendations.
> --
> Andrew J. Kelly SQL MVP
>
> "David Gugick" <davidg-nospam@.imceda.com> wrote in message
> news:eVg9MapGFHA.3076@.tk2msftngp13.phx.gbl...
>
|||Hi
With 5Gb DB, the native Backup supplied by SQL Server will do.
No need to go compression on such small databases.
Don't forget, once you make a backup with any of the 3rd party backup tools,
if you restore, you need to use the tool too.
On big databases, it does make sense.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Hank Arnold" <rasilon@.aol.com> wrote in message
news:#Z1rnFMHFHA.2276@.TK2MSFTNGP15.phx.gbl...
> What are some ballpark costs? I really don't want to get into the
situation[vbcol=seagreen]
> of being dunned by a vendor when all I want to do is try it out *after* I
> find out whether we can afford it. I'm looking at a single
> SQL server with a database under 5GB...
> --
> Regards,
> Hank Arnold
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23sf6$rpGFHA.3628@.TK2MSFTNGP15.phx.gbl...
our
>
|||Thanks......
Regards,
Hank Arnold
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:ekumOKMHFHA.3072@.tk2msftngp13.phx.gbl...
> Hi
> With 5Gb DB, the native Backup supplied by SQL Server will do.
> No need to go compression on such small databases.
> Don't forget, once you make a backup with any of the 3rd party backup
> tools,
> if you restore, you need to use the tool too.
> On big databases, it does make sense.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Hank Arnold" <rasilon@.aol.com> wrote in message
> news:#Z1rnFMHFHA.2276@.TK2MSFTNGP15.phx.gbl...
> situation
> our
>
|||Mike Epprecht (SQL MVP) wrote:
> Hi
> With 5Gb DB, the native Backup supplied by SQL Server will do.
> No need to go compression on such small databases.
> Don't forget, once you make a backup with any of the 3rd party backup
> tools, if you restore, you need to use the tool too.
>
That's not true with LiteSpeed. We offer a tool that converts LiteSpeed
backups to native format, if necessary.
David Gugick
Imceda Software
www.imceda.com