I am getting this error when trying to bakup a database to a file. I am using the default filename and location. The error message is:
2004-02-29 01:00:00.79 backup BACKUP failed to complete the command BACKUP DATABASE [afdb000001_beSQL] TO DISK = N'd:\SQL Data\MSSQL\BACKUP\fordev.bak' WITH NOINIT , NOUNLOAD , NAME = N'afdb000001_beSQL backup', NOSKIP , STATS = 10, NOFORMAT
Any help would be appreciated.
Chris,
A couple of questions.
1) Do you have enough space on the D drive?
2) What is the D drive? Local SCSI, network drive, CD-ROM, SAN?
This error may occur sometimes when backing up over the network when there are network infrastructure issues.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
|||Did you ever get this resolved?
I am wondering what you did?
Showing posts with label location. Show all posts
Showing posts with label location. Show all posts
Sunday, March 25, 2012
backup error 17055 description 3041
I am getting this error when trying to bakup a database to a file. I am usin
g the default filename and location. The error message is:
2004-02-29 01:00:00.79 backup BACKUP failed to complete the command BACKU
P DATABASE [afdb000001_beSQL] TO DISK = N'd:\SQL Data\MSSQL\BACKUP\ford
ev.bak' WITH NOINIT , NOUNLOAD , NAME = N'afdb000001_beSQL backup', NOSK
IP , STATS = 10, NOFORMAT
Any help would be appreciated.Chris,
A couple of questions.
1) Do you have enough space on the D drive?
2) What is the D drive? Local SCSI, network drive, CD-ROM, SAN?
This error may occur sometimes when backing up over the network when there a
re network infrastructure issues.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk|||Did you ever get this resolved?
I am wondering what you did?
g the default filename and location. The error message is:
2004-02-29 01:00:00.79 backup BACKUP failed to complete the command BACKU
P DATABASE [afdb000001_beSQL] TO DISK = N'd:\SQL Data\MSSQL\BACKUP\ford
ev.bak' WITH NOINIT , NOUNLOAD , NAME = N'afdb000001_beSQL backup', NOSK
IP , STATS = 10, NOFORMAT
Any help would be appreciated.Chris,
A couple of questions.
1) Do you have enough space on the D drive?
2) What is the D drive? Local SCSI, network drive, CD-ROM, SAN?
This error may occur sometimes when backing up over the network when there a
re network infrastructure issues.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk|||Did you ever get this resolved?
I am wondering what you did?
Tuesday, March 20, 2012
Backup Device Location
Is it possible to point a backup device to a network location? I have a mapp
ed drive on my SQL Server to a share on another server (Q: drive). The backu
p device points to that Q drive. However, everytime I run the backup, it say
s it cannot reach the speci
fied location. The drive is mapped and the administrator is logged onto the
server, so there should not be a rights issue.
-BrianBrian,
You are better to use UNC names \\server\share\etc instead of mapped =
drive letters. Mapped drives are local to the account that mapped them, =
and therefore may not be visible to the account that the SQl Server =
service is running under. You need to check what account is being used =
for the MSSQLSERVER service and ensure that account has the necessary =
access rights to the remote server. Who is logged on at the other =
machine will make no difference.
Mike John
"Brian" <anonymous@.discussions.microsoft.com> wrote in message =
news:69161F98-4357-4CD0-900E-A229A9917C95@.microsoft.com...
> Is it possible to point a backup device to a network location? I have =
a mapped drive on my SQL Server to a share on another server (Q: drive). =
The backup device points to that Q drive. However, everytime I run the =
backup, it says it cannot reach the specified location. The drive is =
mapped and the administrator is logged onto the server, so there should =
not be a rights issue.
>=20
> -Brian|||Try using a UNC name instead of a mapped drive letter ie
backup database master to disk = '\\server2\backupshare\master.mak' with
init
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Brian" <anonymous@.discussions.microsoft.com> wrote in message
news:69161F98-4357-4CD0-900E-A229A9917C95@.microsoft.com...
> Is it possible to point a backup device to a network location? I have a
mapped drive on my SQL Server to a share on another server (Q: drive). The
backup device points to that Q drive. However, everytime I run the backup,
it says it cannot reach the specified location. The drive is mapped and the
administrator is logged onto the server, so there should not be a rights
issue.
> -Brian|||The UNC path worked. Thanks.sql
ed drive on my SQL Server to a share on another server (Q: drive). The backu
p device points to that Q drive. However, everytime I run the backup, it say
s it cannot reach the speci
fied location. The drive is mapped and the administrator is logged onto the
server, so there should not be a rights issue.
-BrianBrian,
You are better to use UNC names \\server\share\etc instead of mapped =
drive letters. Mapped drives are local to the account that mapped them, =
and therefore may not be visible to the account that the SQl Server =
service is running under. You need to check what account is being used =
for the MSSQLSERVER service and ensure that account has the necessary =
access rights to the remote server. Who is logged on at the other =
machine will make no difference.
Mike John
"Brian" <anonymous@.discussions.microsoft.com> wrote in message =
news:69161F98-4357-4CD0-900E-A229A9917C95@.microsoft.com...
> Is it possible to point a backup device to a network location? I have =
a mapped drive on my SQL Server to a share on another server (Q: drive). =
The backup device points to that Q drive. However, everytime I run the =
backup, it says it cannot reach the specified location. The drive is =
mapped and the administrator is logged onto the server, so there should =
not be a rights issue.
>=20
> -Brian|||Try using a UNC name instead of a mapped drive letter ie
backup database master to disk = '\\server2\backupshare\master.mak' with
init
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Brian" <anonymous@.discussions.microsoft.com> wrote in message
news:69161F98-4357-4CD0-900E-A229A9917C95@.microsoft.com...
> Is it possible to point a backup device to a network location? I have a
mapped drive on my SQL Server to a share on another server (Q: drive). The
backup device points to that Q drive. However, everytime I run the backup,
it says it cannot reach the specified location. The drive is mapped and the
administrator is logged onto the server, so there should not be a rights
issue.
> -Brian|||The UNC path worked. Thanks.sql
Backup Device
I am trying to add a backup device to SQL that will use our NAS. When I enter
the UNC \\ProCom-SERVER\BACKUP\DISK.BAK for the file location I get a message
that SQL Server can not verify the existenance of the backup file location.
The path \\PROCOM-SERVER\BACKUP exist and I use it for other backup files.
The SQL Server is a stand alone server and is not a member of a domain and
neither is the NAS, this is in a peer to peer workgroup network. I have
applied service pack 4 as well.
Any help will be appreciated.
Does the account that SQL Server is running under have rights to that share
on the NAS?
Andrew J. Kelly SQL MVP
"ProCom" <ProCom@.discussions.microsoft.com> wrote in message
news:5FB2ABE4-6012-46AF-910C-C375DA6D6ABA@.microsoft.com...
>I am trying to add a backup device to SQL that will use our NAS. When I
>enter
> the UNC \\ProCom-SERVER\BACKUP\DISK.BAK for the file location I get a
> message
> that SQL Server can not verify the existenance of the backup file
> location.
> The path \\PROCOM-SERVER\BACKUP exist and I use it for other backup files.
> The SQL Server is a stand alone server and is not a member of a domain and
> neither is the NAS, this is in a peer to peer workgroup network. I have
> applied service pack 4 as well.
>
> Any help will be appreciated.
>
the UNC \\ProCom-SERVER\BACKUP\DISK.BAK for the file location I get a message
that SQL Server can not verify the existenance of the backup file location.
The path \\PROCOM-SERVER\BACKUP exist and I use it for other backup files.
The SQL Server is a stand alone server and is not a member of a domain and
neither is the NAS, this is in a peer to peer workgroup network. I have
applied service pack 4 as well.
Any help will be appreciated.
Does the account that SQL Server is running under have rights to that share
on the NAS?
Andrew J. Kelly SQL MVP
"ProCom" <ProCom@.discussions.microsoft.com> wrote in message
news:5FB2ABE4-6012-46AF-910C-C375DA6D6ABA@.microsoft.com...
>I am trying to add a backup device to SQL that will use our NAS. When I
>enter
> the UNC \\ProCom-SERVER\BACKUP\DISK.BAK for the file location I get a
> message
> that SQL Server can not verify the existenance of the backup file
> location.
> The path \\PROCOM-SERVER\BACKUP exist and I use it for other backup files.
> The SQL Server is a stand alone server and is not a member of a domain and
> neither is the NAS, this is in a peer to peer workgroup network. I have
> applied service pack 4 as well.
>
> Any help will be appreciated.
>
Backup Device
I am trying to add a backup device to SQL that will use our NAS. When I ente
r
the UNC \\ProCom-SERVER\BACKUP\DISK.BAK for the file location I get a messag
e
that SQL Server can not verify the existenance of the backup file location.
The path \\PROCOM-SERVER\BACKUP exist and I use it for other backup files.
The SQL Server is a stand alone server and is not a member of a domain and
neither is the NAS, this is in a peer to peer workgroup network. I have
applied service pack 4 as well.
Any help will be appreciated.Does the account that SQL Server is running under have rights to that share
on the NAS?
Andrew J. Kelly SQL MVP
"ProCom" <ProCom@.discussions.microsoft.com> wrote in message
news:5FB2ABE4-6012-46AF-910C-C375DA6D6ABA@.microsoft.com...
>I am trying to add a backup device to SQL that will use our NAS. When I
>enter
> the UNC \\ProCom-SERVER\BACKUP\DISK.BAK for the file location I get a
> message
> that SQL Server can not verify the existenance of the backup file
> location.
> The path \\PROCOM-SERVER\BACKUP exist and I use it for other backup files.
> The SQL Server is a stand alone server and is not a member of a domain and
> neither is the NAS, this is in a peer to peer workgroup network. I have
> applied service pack 4 as well.
>
> Any help will be appreciated.
>
r
the UNC \\ProCom-SERVER\BACKUP\DISK.BAK for the file location I get a messag
e
that SQL Server can not verify the existenance of the backup file location.
The path \\PROCOM-SERVER\BACKUP exist and I use it for other backup files.
The SQL Server is a stand alone server and is not a member of a domain and
neither is the NAS, this is in a peer to peer workgroup network. I have
applied service pack 4 as well.
Any help will be appreciated.Does the account that SQL Server is running under have rights to that share
on the NAS?
Andrew J. Kelly SQL MVP
"ProCom" <ProCom@.discussions.microsoft.com> wrote in message
news:5FB2ABE4-6012-46AF-910C-C375DA6D6ABA@.microsoft.com...
>I am trying to add a backup device to SQL that will use our NAS. When I
>enter
> the UNC \\ProCom-SERVER\BACKUP\DISK.BAK for the file location I get a
> message
> that SQL Server can not verify the existenance of the backup file
> location.
> The path \\PROCOM-SERVER\BACKUP exist and I use it for other backup files.
> The SQL Server is a stand alone server and is not a member of a domain and
> neither is the NAS, this is in a peer to peer workgroup network. I have
> applied service pack 4 as well.
>
> Any help will be appreciated.
>
Backup Device
I am trying to add a backup device to SQL that will use our NAS. When I enter
the UNC \\ProCom-SERVER\BACKUP\DISK.BAK for the file location I get a message
that SQL Server can not verify the existenance of the backup file location.
The path \\PROCOM-SERVER\BACKUP exist and I use it for other backup files.
The SQL Server is a stand alone server and is not a member of a domain and
neither is the NAS, this is in a peer to peer workgroup network. I have
applied service pack 4 as well.
Any help will be appreciated.Does the account that SQL Server is running under have rights to that share
on the NAS?
--
Andrew J. Kelly SQL MVP
"ProCom" <ProCom@.discussions.microsoft.com> wrote in message
news:5FB2ABE4-6012-46AF-910C-C375DA6D6ABA@.microsoft.com...
>I am trying to add a backup device to SQL that will use our NAS. When I
>enter
> the UNC \\ProCom-SERVER\BACKUP\DISK.BAK for the file location I get a
> message
> that SQL Server can not verify the existenance of the backup file
> location.
> The path \\PROCOM-SERVER\BACKUP exist and I use it for other backup files.
> The SQL Server is a stand alone server and is not a member of a domain and
> neither is the NAS, this is in a peer to peer workgroup network. I have
> applied service pack 4 as well.
>
> Any help will be appreciated.
>
the UNC \\ProCom-SERVER\BACKUP\DISK.BAK for the file location I get a message
that SQL Server can not verify the existenance of the backup file location.
The path \\PROCOM-SERVER\BACKUP exist and I use it for other backup files.
The SQL Server is a stand alone server and is not a member of a domain and
neither is the NAS, this is in a peer to peer workgroup network. I have
applied service pack 4 as well.
Any help will be appreciated.Does the account that SQL Server is running under have rights to that share
on the NAS?
--
Andrew J. Kelly SQL MVP
"ProCom" <ProCom@.discussions.microsoft.com> wrote in message
news:5FB2ABE4-6012-46AF-910C-C375DA6D6ABA@.microsoft.com...
>I am trying to add a backup device to SQL that will use our NAS. When I
>enter
> the UNC \\ProCom-SERVER\BACKUP\DISK.BAK for the file location I get a
> message
> that SQL Server can not verify the existenance of the backup file
> location.
> The path \\PROCOM-SERVER\BACKUP exist and I use it for other backup files.
> The SQL Server is a stand alone server and is not a member of a domain and
> neither is the NAS, this is in a peer to peer workgroup network. I have
> applied service pack 4 as well.
>
> Any help will be appreciated.
>
Wednesday, March 7, 2012
backup and restore Question
I had used to make full backup of a database and using winzip to compress
the file to transfer it via email to another location. And because of the
big email attachement of the compressed database I didn't succeed in
transfering the data. Then I tried to alter the database as adding a
secondary group file with 2 files.
and I tried to backup the files each indivually and on the another location
(SERVER) I tried to restore the files but I didn't succeed.
How Can I achieve this goal without any errors ?How about just backup the db and then handling both files? When you backup
the db, both files are backed up.
"Awada" <awada@.pharmacare-ltd.com> wrote in message
news:OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl...
> I had used to make full backup of a database and using winzip to compress
> the file to transfer it via email to another location. And because of the
> big email attachement of the compressed database I didn't succeed in
> transfering the data. Then I tried to alter the database as adding a
> secondary group file with 2 files.
> and I tried to backup the files each indivually and on the another
location
> (SERVER) I tried to restore the files but I didn't succeed.
> How Can I achieve this goal without any errors ?
>|||Whatever number of files you have, the db backup should back them all up.
Then you can compress them all, mail them all, restore the db with them
all -- treating the group of files the same as if there were only one file.
"Awada" <awada@.pharmacare-ltd.com> wrote in message
news:OFvJ0PxPDHA.3236@.TK2MSFTNGP10.phx.gbl...
> The Goal is to get 3 or more files to compress and send via email not one
> big file
>
> "Quentin Ran" <quentinran@.yahoo.com> wrote in message
> news:#m6oUIxPDHA.3192@.TK2MSFTNGP10.phx.gbl...
> > How about just backup the db and then handling both files? When you
> backup
> > the db, both files are backed up.
> >
> > "Awada" <awada@.pharmacare-ltd.com> wrote in message
> > news:OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl...
> > > I had used to make full backup of a database and using winzip to
> compress
> > > the file to transfer it via email to another location. And because of
> the
> > > big email attachement of the compressed database I didn't succeed in
> > > transfering the data. Then I tried to alter the database as adding a
> > > secondary group file with 2 files.
> > > and I tried to backup the files each indivually and on the another
> > location
> > > (SERVER) I tried to restore the files but I didn't succeed.
> > > How Can I achieve this goal without any errors ?
> > >
> > >
> >
> >
>|||I backup DBs on production server, zip them into a RAR file (170 MB) and
schedule a DTS job to FTP the file to an off-site location. How big is your
attachment?
"Awada" <awada@.pharmacare-ltd.com> wrote in message
news:OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl...
> I had used to make full backup of a database and using winzip to compress
> the file to transfer it via email to another location. And because of the
> big email attachement of the compressed database I didn't succeed in
> transfering the data. Then I tried to alter the database as adding a
> secondary group file with 2 files.
> and I tried to backup the files each indivually and on the another
location
> (SERVER) I tried to restore the files but I didn't succeed.
> How Can I achieve this goal without any errors ?
>|||Doesn't winzip give an option to split the zip file into
multiple files? Don't have it installed here to check.
>--Original Message--
>Whatever number of files you have, the db backup should
back them all up.
>Then you can compress them all, mail them all, restore
the db with them
>all -- treating the group of files the same as if there
were only one file.
>"Awada" <awada@.pharmacare-ltd.com> wrote in message
>news:OFvJ0PxPDHA.3236@.TK2MSFTNGP10.phx.gbl...
>> The Goal is to get 3 or more files to compress and send
via email not one
>> big file
>>
>> "Quentin Ran" <quentinran@.yahoo.com> wrote in message
>> news:#m6oUIxPDHA.3192@.TK2MSFTNGP10.phx.gbl...
>> > How about just backup the db and then handling both
files? When you
>> backup
>> > the db, both files are backed up.
>> >
>> > "Awada" <awada@.pharmacare-ltd.com> wrote in message
>> > news:OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl...
>> > > I had used to make full backup of a database and
using winzip to
>> compress
>> > > the file to transfer it via email to another
location. And because of
>> the
>> > > big email attachement of the compressed database I
didn't succeed in
>> > > transfering the data. Then I tried to alter the
database as adding a
>> > > secondary group file with 2 files.
>> > > and I tried to backup the files each indivually and
on the another
>> > location
>> > > (SERVER) I tried to restore the files but I didn't
succeed.
>> > > How Can I achieve this goal without any errors ?
>> > >
>> > >
>> >
>> >
>>
>
>.
>|||Awada -
I follow this process -
1. Backup the Database
2. Rar the DB (Ours is too large for winzip)
3. FTP the database to the remote server
4. Unrar and restore on remote server
This whole process can be automated in a couple of different ways if
you want to (I did).
HTH
"Awada" <awada@.pharmacare-ltd.com> wrote in message news:<OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl>...
> I had used to make full backup of a database and using winzip to compress
> the file to transfer it via email to another location. And because of the
> big email attachement of the compressed database I didn't succeed in
> transfering the data. Then I tried to alter the database as adding a
> secondary group file with 2 files.
> and I tried to backup the files each indivually and on the another location
> (SERVER) I tried to restore the files but I didn't succeed.
> How Can I achieve this goal without any errors ?
the file to transfer it via email to another location. And because of the
big email attachement of the compressed database I didn't succeed in
transfering the data. Then I tried to alter the database as adding a
secondary group file with 2 files.
and I tried to backup the files each indivually and on the another location
(SERVER) I tried to restore the files but I didn't succeed.
How Can I achieve this goal without any errors ?How about just backup the db and then handling both files? When you backup
the db, both files are backed up.
"Awada" <awada@.pharmacare-ltd.com> wrote in message
news:OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl...
> I had used to make full backup of a database and using winzip to compress
> the file to transfer it via email to another location. And because of the
> big email attachement of the compressed database I didn't succeed in
> transfering the data. Then I tried to alter the database as adding a
> secondary group file with 2 files.
> and I tried to backup the files each indivually and on the another
location
> (SERVER) I tried to restore the files but I didn't succeed.
> How Can I achieve this goal without any errors ?
>|||Whatever number of files you have, the db backup should back them all up.
Then you can compress them all, mail them all, restore the db with them
all -- treating the group of files the same as if there were only one file.
"Awada" <awada@.pharmacare-ltd.com> wrote in message
news:OFvJ0PxPDHA.3236@.TK2MSFTNGP10.phx.gbl...
> The Goal is to get 3 or more files to compress and send via email not one
> big file
>
> "Quentin Ran" <quentinran@.yahoo.com> wrote in message
> news:#m6oUIxPDHA.3192@.TK2MSFTNGP10.phx.gbl...
> > How about just backup the db and then handling both files? When you
> backup
> > the db, both files are backed up.
> >
> > "Awada" <awada@.pharmacare-ltd.com> wrote in message
> > news:OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl...
> > > I had used to make full backup of a database and using winzip to
> compress
> > > the file to transfer it via email to another location. And because of
> the
> > > big email attachement of the compressed database I didn't succeed in
> > > transfering the data. Then I tried to alter the database as adding a
> > > secondary group file with 2 files.
> > > and I tried to backup the files each indivually and on the another
> > location
> > > (SERVER) I tried to restore the files but I didn't succeed.
> > > How Can I achieve this goal without any errors ?
> > >
> > >
> >
> >
>|||I backup DBs on production server, zip them into a RAR file (170 MB) and
schedule a DTS job to FTP the file to an off-site location. How big is your
attachment?
"Awada" <awada@.pharmacare-ltd.com> wrote in message
news:OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl...
> I had used to make full backup of a database and using winzip to compress
> the file to transfer it via email to another location. And because of the
> big email attachement of the compressed database I didn't succeed in
> transfering the data. Then I tried to alter the database as adding a
> secondary group file with 2 files.
> and I tried to backup the files each indivually and on the another
location
> (SERVER) I tried to restore the files but I didn't succeed.
> How Can I achieve this goal without any errors ?
>|||Doesn't winzip give an option to split the zip file into
multiple files? Don't have it installed here to check.
>--Original Message--
>Whatever number of files you have, the db backup should
back them all up.
>Then you can compress them all, mail them all, restore
the db with them
>all -- treating the group of files the same as if there
were only one file.
>"Awada" <awada@.pharmacare-ltd.com> wrote in message
>news:OFvJ0PxPDHA.3236@.TK2MSFTNGP10.phx.gbl...
>> The Goal is to get 3 or more files to compress and send
via email not one
>> big file
>>
>> "Quentin Ran" <quentinran@.yahoo.com> wrote in message
>> news:#m6oUIxPDHA.3192@.TK2MSFTNGP10.phx.gbl...
>> > How about just backup the db and then handling both
files? When you
>> backup
>> > the db, both files are backed up.
>> >
>> > "Awada" <awada@.pharmacare-ltd.com> wrote in message
>> > news:OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl...
>> > > I had used to make full backup of a database and
using winzip to
>> compress
>> > > the file to transfer it via email to another
location. And because of
>> the
>> > > big email attachement of the compressed database I
didn't succeed in
>> > > transfering the data. Then I tried to alter the
database as adding a
>> > > secondary group file with 2 files.
>> > > and I tried to backup the files each indivually and
on the another
>> > location
>> > > (SERVER) I tried to restore the files but I didn't
succeed.
>> > > How Can I achieve this goal without any errors ?
>> > >
>> > >
>> >
>> >
>>
>
>.
>|||Awada -
I follow this process -
1. Backup the Database
2. Rar the DB (Ours is too large for winzip)
3. FTP the database to the remote server
4. Unrar and restore on remote server
This whole process can be automated in a couple of different ways if
you want to (I did).
HTH
"Awada" <awada@.pharmacare-ltd.com> wrote in message news:<OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl>...
> I had used to make full backup of a database and using winzip to compress
> the file to transfer it via email to another location. And because of the
> big email attachement of the compressed database I didn't succeed in
> transfering the data. Then I tried to alter the database as adding a
> secondary group file with 2 files.
> and I tried to backup the files each indivually and on the another location
> (SERVER) I tried to restore the files but I didn't succeed.
> How Can I achieve this goal without any errors ?
Sunday, February 19, 2012
Backup / Restore script
One of my coworkers needs to programmatically ask a bunch of different SQL
Servers for the default location of where they are configured to put .BAK
files.
Peace & happy computing,
Mike Labosh, MCSD
"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave MustaneMike,
Use the BackupDirectory key.
HTH
Jerry
"Mike Labosh" <mlabosh@.hotmail.com> wrote in message
news:ebE3t010FHA.404@.TK2MSFTNGP09.phx.gbl...
> One of my coworkers needs to programmatically ask a bunch of different SQL
> Servers for the default location of where they are configured to put .BAK
> files.
> --
> Peace & happy computing,
> Mike Labosh, MCSD
> "When you kill a man, you're a murderer.
> Kill many, and you're a conqueror.
> Kill them all and you're a god." -- Dave Mustane
>|||> Use the BackupDirectory key.
I'm not too sure what you mean, but if you mean a Windows Registry Key,
that's no good in this example. He's writing an automated backup utility
that will tell many different SQL Servers via ODBC to backup their
databases. Since his application does not run on the actual SQL servers, he
doesn't have access to their registries.
Peace & happy computing,
Mike Labosh, MCSD
"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave Mustane|||Mike,
Ok...try the SQL-DMO Backup Directory Property (in SQL BOL).
HTH
Jerry
"Mike Labosh" <mlabosh@.hotmail.com> wrote in message
news:OeYlsB20FHA.2888@.TK2MSFTNGP10.phx.gbl...
> I'm not too sure what you mean, but if you mean a Windows Registry Key,
> that's no good in this example. He's writing an automated backup utility
> that will tell many different SQL Servers via ODBC to backup their
> databases. Since his application does not run on the actual SQL servers,
> he doesn't have access to their registries.
> --
> Peace & happy computing,
> Mike Labosh, MCSD
> "When you kill a man, you're a murderer.
> Kill many, and you're a conqueror.
> Kill them all and you're a god." -- Dave Mustane
>|||I agree that using DMO is the way to go. In case you absolutely can't do tha
t, you can use the
*unsupported and undocumented* xp_instance_regread extended proc. All usual
warnings apply:
http://www.sqldev.net/misc/SQLLocationFunctions.htm
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:%23aVzyR20FHA.2964@.TK2MSFTNGP10.phx.gbl...
> Mike,
> Ok...try the SQL-DMO Backup Directory Property (in SQL BOL).
> HTH
> Jerry
> "Mike Labosh" <mlabosh@.hotmail.com> wrote in message news:OeYlsB20FHA.2888
@.TK2MSFTNGP10.phx.gbl...
>
Servers for the default location of where they are configured to put .BAK
files.
Peace & happy computing,
Mike Labosh, MCSD
"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave MustaneMike,
Use the BackupDirectory key.
HTH
Jerry
"Mike Labosh" <mlabosh@.hotmail.com> wrote in message
news:ebE3t010FHA.404@.TK2MSFTNGP09.phx.gbl...
> One of my coworkers needs to programmatically ask a bunch of different SQL
> Servers for the default location of where they are configured to put .BAK
> files.
> --
> Peace & happy computing,
> Mike Labosh, MCSD
> "When you kill a man, you're a murderer.
> Kill many, and you're a conqueror.
> Kill them all and you're a god." -- Dave Mustane
>|||> Use the BackupDirectory key.
I'm not too sure what you mean, but if you mean a Windows Registry Key,
that's no good in this example. He's writing an automated backup utility
that will tell many different SQL Servers via ODBC to backup their
databases. Since his application does not run on the actual SQL servers, he
doesn't have access to their registries.
Peace & happy computing,
Mike Labosh, MCSD
"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave Mustane|||Mike,
Ok...try the SQL-DMO Backup Directory Property (in SQL BOL).
HTH
Jerry
"Mike Labosh" <mlabosh@.hotmail.com> wrote in message
news:OeYlsB20FHA.2888@.TK2MSFTNGP10.phx.gbl...
> I'm not too sure what you mean, but if you mean a Windows Registry Key,
> that's no good in this example. He's writing an automated backup utility
> that will tell many different SQL Servers via ODBC to backup their
> databases. Since his application does not run on the actual SQL servers,
> he doesn't have access to their registries.
> --
> Peace & happy computing,
> Mike Labosh, MCSD
> "When you kill a man, you're a murderer.
> Kill many, and you're a conqueror.
> Kill them all and you're a god." -- Dave Mustane
>|||I agree that using DMO is the way to go. In case you absolutely can't do tha
t, you can use the
*unsupported and undocumented* xp_instance_regread extended proc. All usual
warnings apply:
http://www.sqldev.net/misc/SQLLocationFunctions.htm
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:%23aVzyR20FHA.2964@.TK2MSFTNGP10.phx.gbl...
> Mike,
> Ok...try the SQL-DMO Backup Directory Property (in SQL BOL).
> HTH
> Jerry
> "Mike Labosh" <mlabosh@.hotmail.com> wrote in message news:OeYlsB20FHA.2888
@.TK2MSFTNGP10.phx.gbl...
>
Tuesday, February 14, 2012
Backup
I'm working with a database server placed in a datacenter remotely placed fr
om my work location, and accessing the database through Enterprise Manager a
nd Quesry Analyser connected via Internet.
The backup is scheduled and log-shipping is implemented with another server
in the datacenter. But I want to take backup and store backup files in my lo
cal machine. Can I do this or I have to get the files from the database ser
ver through some FTP or oth
er protocol.
Thanks in advance but plz do help meSunil
BACKUP DATABASE DatabaseName TO DISK =
N'\\Server\backup\databasename.BAK'
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:08D9D28D-E45A-4208-BF2C-6D5E15B9B1B6@.microsoft.com...
from my work location, and accessing the database through Enterprise Manager
and Quesry Analyser connected via Internet.
server in the datacenter. But I want to take backup and store backup files
in my local machine. Can I do this or I have to get the files from the
database server through some FTP or other protocol.
I use \\ unc path.|||assumed you have SQL installed on your local machine or a machine on local
network and there is an FTP server at the remote network,
on the remote server you can use winrar (has more compression ratio then
winzip) to compress the backups, use DTS on to schedule an FTP job to
transfer the rar file to you local machine.
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:76683E68-071B-42B1-9AFB-8E598E81FBF2@.microsoft.com...
can I use \\ unc path.
om my work location, and accessing the database through Enterprise Manager a
nd Quesry Analyser connected via Internet.
The backup is scheduled and log-shipping is implemented with another server
in the datacenter. But I want to take backup and store backup files in my lo
cal machine. Can I do this or I have to get the files from the database ser
ver through some FTP or oth
er protocol.
Thanks in advance but plz do help meSunil
BACKUP DATABASE DatabaseName TO DISK =
N'\\Server\backup\databasename.BAK'
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:08D9D28D-E45A-4208-BF2C-6D5E15B9B1B6@.microsoft.com...
quote:
> I'm working with a database server placed in a datacenter remotely placed
from my work location, and accessing the database through Enterprise Manager
and Quesry Analyser connected via Internet.
quote:
> The backup is scheduled and log-shipping is implemented with another
server in the datacenter. But I want to take backup and store backup files
in my local machine. Can I do this or I have to get the files from the
database server through some FTP or other protocol.
quote:|||When I'm accessing the database server through the internet link so how can
>
> Thanks in advance but plz do help me
I use \\ unc path.|||assumed you have SQL installed on your local machine or a machine on local
network and there is an FTP server at the remote network,
on the remote server you can use winrar (has more compression ratio then
winzip) to compress the backups, use DTS on to schedule an FTP job to
transfer the rar file to you local machine.
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:76683E68-071B-42B1-9AFB-8E598E81FBF2@.microsoft.com...
quote:
> When I'm accessing the database server through the internet link so how
can I use \\ unc path.
Sunday, February 12, 2012
Backup
I'm working with a database server placed in a datacenter remotely placed from my work location, and accessing the database through Enterprise Manager and Quesry Analyser connected via Internet.
The backup is scheduled and log-shipping is implemented with another server in the datacenter. But I want to take backup and store backup files in my local machine. Can I do this or I have to get the files from the database server through some FTP or other protocol.
Thanks in advance but plz do help meSunil
BACKUP DATABASE DatabaseName TO DISK = N'\\Server\backup\databasename.BAK'
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:08D9D28D-E45A-4208-BF2C-6D5E15B9B1B6@.microsoft.com...
> I'm working with a database server placed in a datacenter remotely placed
from my work location, and accessing the database through Enterprise Manager
and Quesry Analyser connected via Internet.
> The backup is scheduled and log-shipping is implemented with another
server in the datacenter. But I want to take backup and store backup files
in my local machine. Can I do this or I have to get the files from the
database server through some FTP or other protocol.
>
> Thanks in advance but plz do help me|||When I'm accessing the database server through the internet link so how can I use \\ unc path.|||assumed you have SQL installed on your local machine or a machine on local
network and there is an FTP server at the remote network,
on the remote server you can use winrar (has more compression ratio then
winzip) to compress the backups, use DTS on to schedule an FTP job to
transfer the rar file to you local machine.
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:76683E68-071B-42B1-9AFB-8E598E81FBF2@.microsoft.com...
> When I'm accessing the database server through the internet link so how
can I use \\ unc path.
The backup is scheduled and log-shipping is implemented with another server in the datacenter. But I want to take backup and store backup files in my local machine. Can I do this or I have to get the files from the database server through some FTP or other protocol.
Thanks in advance but plz do help meSunil
BACKUP DATABASE DatabaseName TO DISK = N'\\Server\backup\databasename.BAK'
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:08D9D28D-E45A-4208-BF2C-6D5E15B9B1B6@.microsoft.com...
> I'm working with a database server placed in a datacenter remotely placed
from my work location, and accessing the database through Enterprise Manager
and Quesry Analyser connected via Internet.
> The backup is scheduled and log-shipping is implemented with another
server in the datacenter. But I want to take backup and store backup files
in my local machine. Can I do this or I have to get the files from the
database server through some FTP or other protocol.
>
> Thanks in advance but plz do help me|||When I'm accessing the database server through the internet link so how can I use \\ unc path.|||assumed you have SQL installed on your local machine or a machine on local
network and there is an FTP server at the remote network,
on the remote server you can use winrar (has more compression ratio then
winzip) to compress the backups, use DTS on to schedule an FTP job to
transfer the rar file to you local machine.
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:76683E68-071B-42B1-9AFB-8E598E81FBF2@.microsoft.com...
> When I'm accessing the database server through the internet link so how
can I use \\ unc path.
Friday, February 10, 2012
Backing up to Network Location
Is there a way to get SQL Server to backup to a file on the network? I have tried running the SQL Server Agent under login with suitable access and using a UNC path. The SQL Server 2000 Maintenance Plan Wizard only allows you to browse to local drives which seems to indicate that this is true. The SQL 2005 Maintenance Plan looks more flexible but I haven't explored that possibility yet.
I solve the problem with a bit of VBScipt that copies the files and cleans up any old files on the local drive and on the network but I am curious as to whether there is another way. One reason for not alowing this could be to maximise the chance of the drive being available I suppose.
Thanks,
Dick Campbell
If you're running an Agent job to do the backup, SQL Agent has to have permissions on the network share. If you're executing a backup statement then the SQL Server process has to have permissions on the share and you have to be logged in as an admin.
Not sure about the Maintenance Plan Wizard behavior.
|||Thanks, I thought that I had tried using an appropriate Agent login and network share. I will try again.
|||Now I am really confused. I tried the SQL Server Agent running under my login (with rights to the network) and I copied and pasted the UNC for the network location from Windows Explorer into the backup path. When I do this, the Job fails. My alternative approach, which is a VBScript Step in a Job that copies the backup files to exactly the same network location fails with the SQL Server Agent running under the local system account but succeeds if I run it under my login.
Thanks for your replies so far.
|||If the Sql server startup account is local system the job will fail because with local system you cannot access the network resources .............the sql server startup account needs to be a ID which has access to network resourcesAnd I guess since your id has has the necessary privileges to the network path you would have executed the backup command in the query analyzer and it would hav e succeeded i guess...........Always if you run it as a job you will need the startup account to be an id other than local system.............
|||
I got it working today by running the SQL Server Service under a login with network access rather than just the SQL Server Agent Service. I am not yet whether BOTH services need such a login.
It seems that SQL Server is set up to discourage direct backups over the network and I am not sure whether this id by design.
Any comments on the pros and cons of baking up directly to a network location?
Backing up to Network Location
Is there a way to get SQL Server to backup to a file on the network? I have tried running the SQL Server Agent under login with suitable access and using a UNC path. The SQL Server 2000 Maintenance Plan Wizard only allows you to browse to local drives which seems to indicate that this is true. The SQL 2005 Maintenance Plan looks more flexible but I haven't explored that possibility yet.
I solve the problem with a bit of VBScipt that copies the files and cleans up any old files on the local drive and on the network but I am curious as to whether there is another way. One reason for not alowing this could be to maximise the chance of the drive being available I suppose.
Thanks,
Dick Campbell
If you're running an Agent job to do the backup, SQL Agent has to have permissions on the network share. If you're executing a backup statement then the SQL Server process has to have permissions on the share and you have to be logged in as an admin.
Not sure about the Maintenance Plan Wizard behavior.
|||Thanks, I thought that I had tried using an appropriate Agent login and network share. I will try again.
|||Now I am really confused. I tried the SQL Server Agent running under my login (with rights to the network) and I copied and pasted the UNC for the network location from Windows Explorer into the backup path. When I do this, the Job fails. My alternative approach, which is a VBScript Step in a Job that copies the backup files to exactly the same network location fails with the SQL Server Agent running under the local system account but succeeds if I run it under my login.
Thanks for your replies so far.
|||If the Sql server startup account is local system the job will fail because with local system you cannot access the network resources .............the sql server startup account needs to be a ID which has access to network resourcesAnd I guess since your id has has the necessary privileges to the network path you would have executed the backup command in the query analyzer and it would hav e succeeded i guess...........Always if you run it as a job you will need the startup account to be an id other than local system.............
|||
I got it working today by running the SQL Server Service under a login with network access rather than just the SQL Server Agent Service. I am not yet whether BOTH services need such a login.
It seems that SQL Server is set up to discourage direct backups over the network and I am not sure whether this id by design.
Any comments on the pros and cons of baking up directly to a network location?
Subscribe to:
Posts (Atom)