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, 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|||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 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.
>

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.
>

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
BC
You 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, 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
|||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 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.
>

Question on an unuall issue in SQL reporting Service

There is a developer here running a report using SQL reporting services, It
is a fairly large report and it seems to run fine, But when he tries to
export it to a CSV or EXCEL, it runs for two minutes then brings up an
authentication window, After he inputs his credentials it runs approx another
two minutes then wants him to re-authenticate, after the third instance of
this it fails and will not export. However if he tries to export a smaller
file, it works Okay. One caviat, I recieve an Event ID:10016 around the same
time and it says something about The COM not having a required permission, is
this a factor in my issue?
--
Scott A Cummins
Sr. Systems Engineer
Equity Analytics
( A division of Merrill Lynch)
14614 N. Keirland Blvd
Scottsdale, AZ 85254
480-998-3515On Mar 9, 12:19 pm, Scott Cummins <scumm...@.equitymethods.com> wrote:
> There is a developer here running a report using SQL reporting services, It
> is a fairly large report and it seems to run fine, But when he tries to
> export it to a CSV or EXCEL, it runs for two minutes then brings up an
> authentication window, After he inputs his credentials it runs approx another
> two minutes then wants him to re-authenticate, after the third instance of
> this it fails and will not export. However if he tries to export a smaller
> file, it works Okay. One caviat, I recieve an Event ID:10016 around the same
> time and it says something about The COM not having a required permission, is
> this a factor in my issue?
> --
> Scott A Cummins
> Sr. Systems Engineer
> Equity Analytics
> ( A division of Merrill Lynch)
> 14614 N. Keirland Blvd
> Scottsdale, AZ 85254
> 480-998-3515
It sounds like it. Normally, once a datasource has been set up for a
report, there is no further authentication necessary. Also, I myself
have never seen this occur when exporting to any format w/Reporting
Services (and I don't utilize COM objects in the process).
Regards,
Enrique Martinez
Sr. SQL Server Developer