Question on backups

I have a database that is fairly large (12gb) that needs to be backed
up, and all things considered, I'd like to have it backed up to another
box on our network - one with much more space available so that I could
keep several instances on that source at one time.
Database maintenance plans only give me the option to select a local drive.
Is there a way to back up across the network from a server to a second
one, and if so how?
Thanks
BCYou can write the UNC path in the maint wizard. Or you can create "regular"
agent job that executes
the BACKUP command using the UNC naming. The SQL Server service account need
permissions to the
share.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Blasting Cap" <goober@.christian.net> wrote in message
news:%23jWObAbcFHA.3828@.tk2msftngp13.phx.gbl...
>I have a database that is fairly large (12gb) that needs to be backed up, a
nd all things
>considered, I'd like to have it backed up to another box on our network - o
ne with much more space
>available so that I could keep several instances on that source at one time
.
> Database maintenance plans only give me the option to select a local drive
.
> Is there a way to back up across the network from a server to a second one
, and if so how?
> Thanks
> BC|||See if this helps:
http://vyaskn.tripod.com/administration_faq.htm#q17
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Blasting Cap" <goober@.christian.net> wrote in message
news:%23jWObAbcFHA.3828@.tk2msftngp13.phx.gbl...
I have a database that is fairly large (12gb) that needs to be backed
up, and all things considered, I'd like to have it backed up to another
box on our network - one with much more space available so that I could
keep several instances on that source at one time.
Database maintenance plans only give me the option to select a local drive.
Is there a way to back up across the network from a server to a second
one, and if so how?
Thanks
BC|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
"Blasting Cap" <goober@.christian.net> wrote in message
news:%23jWObAbcFHA.3828@.tk2msftngp13.phx.gbl...
>I have a database that is fairly large (12gb) that needs to be backed up,
>and all things considered, I'd like to have it backed up to another box on
>our network - one with much more space available so that I could keep
>several instances on that source at one time.
> Database maintenance plans only give me the option to select a local
> drive.
> Is there a way to back up across the network from a server to a second
> one, and if so how?
> Thanks
> BC|||In addition to the others you might consider using one of the 3rd party
backup tools that do in-line compression. This will shorten the backup time
since the file written over the network is much smaller. And you will be
able to store even more files with the same space.
Andrew J. Kelly SQL MVP
"Blasting Cap" <goober@.christian.net> wrote in message
news:%23jWObAbcFHA.3828@.tk2msftngp13.phx.gbl...
>I have a database that is fairly large (12gb) that needs to be backed up,
>and all things considered, I'd like to have it backed up to another box on
>our network - one with much more space available so that I could keep
>several instances on that source at one time.
> Database maintenance plans only give me the option to select a local
> drive.
> Is there a way to back up across the network from a server to a second
> one, and if so how?
> Thanks
> BC|||To everyone - thank you for the suggestions, links and advice. I
believe I can make it work.
Andrew J. Kelly wrote:
> In addition to the others you might consider using one of the 3rd party
> backup tools that do in-line compression. This will shorten the backup ti
me
> since the file written over the network is much smaller. And you will be
> able to store even more files with the same space.
>