I have a client who would like to automate the backup. I have used nti
backup for cd's and microsofts backup utility that came with windows
2000. They both state that the files cannot be backed up because the
files are in use.
any Ideas on how to automate the backup' and bypass the exclusive
holdings of the files'Yes. You have to tell SQL Server to backup the database to a file.
Then you can backup the file using whatever backup utility you like.
The command looks like this:
BACKUP DATABASE foo TO DISK = 'x:\foo.bak' WITH INIT
After the command is executed within SQL Server (HINT: you can schedule a
job to run automatically within the SQL Server Agent) the file will be in
the location specified (the root of the X drive in this example).
Keith Kratochvil
"Mike Ryan" <miker@.centralutahcomputers.com> wrote in message
news:%23IVw6PNhGHA.4104@.TK2MSFTNGP04.phx.gbl...
> I have a client who would like to automate the backup. I have used nti
> backup for cd's and microsofts backup utility that came with windows 2000.
> They both state that the files cannot be backed up because the files are
> in use.
> any Ideas on how to automate the backup' and bypass the exclusive
> holdings of the files'
>|||Keith Kratochvil wrote:
> Yes. You have to tell SQL Server to backup the database to a file.
> Then you can backup the file using whatever backup utility you like.
> The command looks like this:
> BACKUP DATABASE foo TO DISK = 'x:\foo.bak' WITH INIT
> After the command is executed within SQL Server (HINT: you can schedule a
> job to run automatically within the SQL Server Agent) the file will be in
> the location specified (the root of the X drive in this example).
>
Additionally you (or your client) should read up on BACKUP and RESTORE
strategy in Books On Line. It sounds like you aren't very familiar with
SQL backups but there are a few concepts you need to be aware of like
Recovery Model (FULL/SIMPLE), difference between FULL Database backup
and log backup and maybe even more important - RESTORE options.
Regards
Steen Schlter Persson
DBA|||Good point!
Knowing how to backup and restore a database is very important. Books
Online is a great resource and contains good information.
Keith Kratochvil
"Steen Persson (DK)" <spe@.REMOVEdatea.dk> wrote in message
news:%23LLSG3XhGHA.3572@.TK2MSFTNGP04.phx.gbl...
> Keith Kratochvil wrote:
> Additionally you (or your client) should read up on BACKUP and RESTORE
> strategy in Books On Line. It sounds like you aren't very familiar with
> SQL backups but there are a few concepts you need to be aware of like
> Recovery Model (FULL/SIMPLE), difference between FULL Database backup and
> log backup and maybe even more important - RESTORE options.
> --
> Regards
> Steen Schlter Persson
> DBA
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment