Backup to Network Drive: domain

Showing posts with label domain. Show all posts

Wednesday, March 7, 2012

backups failing

Executed as user: domain\bla. The backup data in 'DevBackupDevice2' is
incorrectly formatted. Backups cannot be appended, but existing backup sets
may still be usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is
terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
I got this message this morning when trying to do a full backup. I dropped/
recreated the backup device and then tried again. I got the same message
still.
Any ideas?
SQL2K SP3
TIA, ChrisR
Chris,
Are you backing up to tape? See KB 290787, "PRB: Error Message 3266 Occurs
When Microsoft Tape Backup Format Cannot be Read"
The SQL Server 2000 example references the same error message you are
reporting.
Ron
Ron Talmage
SQL Server MVP
"ChrisR" <bla@.noemail.com> wrote in message
news:O%23VM7h44EHA.3820@.TK2MSFTNGP11.phx.gbl...
> Executed as user: domain\bla. The backup data in 'DevBackupDevice2' is
> incorrectly formatted. Backups cannot be appended, but existing backup
sets
> may still be usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is
> terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
> I got this message this morning when trying to do a full backup. I
dropped/
> recreated the backup device and then tried again. I got the same message
> still.
> Any ideas?
> --
> SQL2K SP3
> TIA, ChrisR
>

backups failing

Executed as user: domain\bla. The backup data in 'DevBackupDevice2' is
incorrectly formatted. Backups cannot be appended, but existing backup sets
may still be usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is
terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
I got this message this morning when trying to do a full backup. I dropped/
recreated the backup device and then tried again. I got the same message
still.
Any ideas?
--
SQL2K SP3
TIA, ChrisRChris,
Are you backing up to tape? See KB 290787, "PRB: Error Message 3266 Occurs
When Microsoft Tape Backup Format Cannot be Read"
The SQL Server 2000 example references the same error message you are
reporting.
Ron
--
Ron Talmage
SQL Server MVP
"ChrisR" <bla@.noemail.com> wrote in message
news:O%23VM7h44EHA.3820@.TK2MSFTNGP11.phx.gbl...
> Executed as user: domain\bla. The backup data in 'DevBackupDevice2' is
> incorrectly formatted. Backups cannot be appended, but existing backup
sets
> may still be usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is
> terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
> I got this message this morning when trying to do a full backup. I
dropped/
> recreated the backup device and then tried again. I got the same message
> still.
> Any ideas?
> --
> SQL2K SP3
> TIA, ChrisR
>

Sunday, February 19, 2012

Backup/Restore MSSQL database from domain host?

My domain host provides Windows hosting, including MS SQL database.
Unfortunately it doesn't provide remote connections to their MS SQL server.
I can see no method of retrieving my database structure, or the database
populated with data, from the hosts control panel.
I'm sure that I could upload a script to my webspace that would allow me to
download and upload my database structures and data, but I have no idea
where to find a script that would allow this.
I'm hoping to be able to develop the database locally, then upload the
changes to the online database. Later I'd like to be able to download the
database to make modifications or just farm the data within them.
Any ideas?You need to ask your provider this. If they don't have a story on how you ca
n backup and get the
database and also upload such a backup, then change provider.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Noozer" <dont.spam@.me.here> wrote in message news:buMTf.164960$H%4.121289@.pd7tw2no...[colo
r=darkred]
> My domain host provides Windows hosting, including MS SQL database. Unfort
unately it doesn't
> provide remote connections to their MS SQL server. I can see no method of
retrieving my database
> structure, or the database populated with data, from the hosts control pan
el.
> I'm sure that I could upload a script to my webspace that would allow me t
o download and upload my
> database structures and data, but I have no idea where to find a script th
at would allow this.
> I'm hoping to be able to develop the database locally, then upload the cha
nges to the online
> database. Later I'd like to be able to download the database to make modif
ications or just farm
> the data within them.
> Any ideas?
>[/color]

Backup/Restore MSSQL database from domain host?

My domain host provides Windows hosting, including MS SQL database.
Unfortunately it doesn't provide remote connections to their MS SQL server.
I can see no method of retrieving my database structure, or the database
populated with data, from the hosts control panel.
I'm sure that I could upload a script to my webspace that would allow me to
download and upload my database structures and data, but I have no idea
where to find a script that would allow this.
I'm hoping to be able to develop the database locally, then upload the
changes to the online database. Later I'd like to be able to download the
database to make modifications or just farm the data within them.
Any ideas?
You need to ask your provider this. If they don't have a story on how you can backup and get the
database and also upload such a backup, then change provider.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Noozer" <dont.spam@.me.here> wrote in message news:buMTf.164960$H%4.121289@.pd7tw2no...
> My domain host provides Windows hosting, including MS SQL database. Unfortunately it doesn't
> provide remote connections to their MS SQL server. I can see no method of retrieving my database
> structure, or the database populated with data, from the hosts control panel.
> I'm sure that I could upload a script to my webspace that would allow me to download and upload my
> database structures and data, but I have no idea where to find a script that would allow this.
> I'm hoping to be able to develop the database locally, then upload the changes to the online
> database. Later I'd like to be able to download the database to make modifications or just farm
> the data within them.
> Any ideas?
>

Monday, February 13, 2012

Backup w/RETAINDAYS just keeps growin', and growin'

Hi all;

I need to make daily backups to a computer in another domain, where I can't map a drive, so I use the TSQL to create a dump device, which works fine:

EXEC sp_addumpdevice 'disk', 'MyBackupDevice', [ipaddress & directory/file]

Then I schedule a server job which faithfully backs up my database, with one hitch - it never deletes days older than 5 as per the code - it just keeps growing. The command couldn't be much simpler:

BACKUP DATABASE ProductionETC to MyBackupDevice WITH RETAINDAYS = 5

For now, I just create a new backup device every now and then and go back and forth, deleting the oldest one when I create a new one. But it's annoying! Any ideas what I'm doing wrong?

Thanks,

L. Rap

RETAINDAYS only prevents SQL Server from overwriting the file unless the specified number of days have elapsed. It doesn't mean that SQL Server will automatically delete the file or erase the media after the specified number of days. So you will have to delete the files using your own scheduled job or use a database maintainence task (you can create from Enterprise Manager or SSMS).|||

Thanks Umachandar, that's very helpful. I misunderstood the instructions.

Would you happen to know if it is possible to delete the earliest backup from the set using T-SQL or some other preset command, or if I need to schedule an OS job to simply delete the file and start over?

Regards,

L. Rap

Sunday, February 12, 2012

Backup to USB drive failing

We have a SQL Server (2000, Win2K) that used to backup to a tape drive. The
tape drive was connected through our Domain Controller. DC crashed. As
emergency solution, a 256GB external USB drive was attached to the SQL
Server, and appears in structure as Drive F:\.
I can manually backup my TLog to the USB drive, but scheduled TLog backups
don't even launch, let alone fail.
I can launch a manual Full Database backup, but it fails, error 112, not
enough disk space. My db is only 50GB, and I have 230GB free on my external
USB drive.
Any ideas why my scheduled (Maintenance Plan) TLog backups don't even
launch, and why the Full backup says I am out of space?
We are using the Administrator login, with full permissions.
Thanks!Make sure your drive is formatted using NTFS, not FAT32.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Duane" <Duane@.discussions.microsoft.com> wrote in message
news:346BBF00-0EFA-4929-A452-DACF33FDE7C0@.microsoft.com...
> We have a SQL Server (2000, Win2K) that used to backup to a tape drive.
> The
> tape drive was connected through our Domain Controller. DC crashed. As
> emergency solution, a 256GB external USB drive was attached to the SQL
> Server, and appears in structure as Drive F:\.
> I can manually backup my TLog to the USB drive, but scheduled TLog backups
> don't even launch, let alone fail.
> I can launch a manual Full Database backup, but it fails, error 112, not
> enough disk space. My db is only 50GB, and I have 230GB free on my
> external
> USB drive.
> Any ideas why my scheduled (Maintenance Plan) TLog backups don't even
> launch, and why the Full backup says I am out of space?
> We are using the Administrator login, with full permissions.
> Thanks!|||Geoff, thanks. It is FAT32, and we will reformat Thursday and try again.
HOWEVER, I still have the issue of why my scheduled backups don't even
launch. This shouldn't have anything to do with formatting, as I can
manually backup a TLog, but it doesn't even launch when scheduled.
Suggestions?
Thanks,
Duane
"Geoff N. Hiten" wrote:
> Make sure your drive is formatted using NTFS, not FAT32.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Duane" <Duane@.discussions.microsoft.com> wrote in message
> news:346BBF00-0EFA-4929-A452-DACF33FDE7C0@.microsoft.com...
> > We have a SQL Server (2000, Win2K) that used to backup to a tape drive.
> > The
> > tape drive was connected through our Domain Controller. DC crashed. As
> > emergency solution, a 256GB external USB drive was attached to the SQL
> > Server, and appears in structure as Drive F:\.
> >
> > I can manually backup my TLog to the USB drive, but scheduled TLog backups
> > don't even launch, let alone fail.
> >
> > I can launch a manual Full Database backup, but it fails, error 112, not
> > enough disk space. My db is only 50GB, and I have 230GB free on my
> > external
> > USB drive.
> >
> > Any ideas why my scheduled (Maintenance Plan) TLog backups don't even
> > launch, and why the Full backup says I am out of space?
> >
> > We are using the Administrator login, with full permissions.
> >
> > Thanks!
>
>|||"Duane" <Duane@.discussions.microsoft.com> wrote in message
news:019B2438-DC3D-41D9-992F-C42B2CA300A4@.microsoft.com...
> Geoff, thanks. It is FAT32, and we will reformat Thursday and try again.
> HOWEVER, I still have the issue of why my scheduled backups don't even
> launch. This shouldn't have anything to do with formatting, as I can
> manually backup a TLog, but it doesn't even launch when scheduled.
GENERALLY I've seen that when folks backup to a shared drive and don't have
permissions right.
But if this is a local drive, that shouldn't be an issue... hmm, unless
somehow the user account SQL Admin is running under hasn't picked up the new
drive letter?
Might want to try cycling SQL Admin.
> Suggestions?
> Thanks,
> Duane
> "Geoff N. Hiten" wrote:
> > Make sure your drive is formatted using NTFS, not FAT32.
> >
> > --
> > Geoff N. Hiten
> > Senior Database Administrator
> > Microsoft SQL Server MVP
> >
> >
> > "Duane" <Duane@.discussions.microsoft.com> wrote in message
> > news:346BBF00-0EFA-4929-A452-DACF33FDE7C0@.microsoft.com...
> > > We have a SQL Server (2000, Win2K) that used to backup to a tape
drive.
> > > The
> > > tape drive was connected through our Domain Controller. DC crashed.
As
> > > emergency solution, a 256GB external USB drive was attached to the SQL
> > > Server, and appears in structure as Drive F:\.
> > >
> > > I can manually backup my TLog to the USB drive, but scheduled TLog
backups
> > > don't even launch, let alone fail.
> > >
> > > I can launch a manual Full Database backup, but it fails, error 112,
not
> > > enough disk space. My db is only 50GB, and I have 230GB free on my
> > > external
> > > USB drive.
> > >
> > > Any ideas why my scheduled (Maintenance Plan) TLog backups don't even
> > > launch, and why the Full backup says I am out of space?
> > >
> > > We are using the Administrator login, with full permissions.
> > >
> > > Thanks!
> >
> >
> >

Backup to USB drive failing

Backup to Storage Server in another domain.

I am attempting to use enterprise manager to backup databases to a
storage server in another domain and was looking for some advice.
Currently the server is running small business server so I cannot
create a trust to the storage servers domain.
I created a mapped drive when logged in as the sql service account but
this did not work.
I was thinking about making a job that used the net use command to
create the drive then running the backup script.
I was wondering if anyone else had a better solution for crossing the
domain security barrier.
Thanks!Hi
I have my doubt that you have by EM backup database on remote computer.
BACKUP DATABASE db TO DISK =
N'\\ServerName\backup\db.BAK'
exec SRV003.master.dbo.sp_executesql N'BACKUP DATABASE pubs
to DISK =''d:\Program Files\Microsoft SQL
Server\MSSQL$BELLTOWER\BACKUP\testback.bak'''
exec SRV003.master.dbo.sp_executesql
N'BACKUP DATABASE pubs to testback'
<outoftherealm@.hotmail.com> wrote in message
news:1143475970.853389.244620@.u72g2000cwu.googlegroups.com...
>I am attempting to use enterprise manager to backup databases to a
> storage server in another domain and was looking for some advice.
> Currently the server is running small business server so I cannot
> create a trust to the storage servers domain.
> I created a mapped drive when logged in as the sql service account but
> this did not work.
> I was thinking about making a job that used the net use command to
> create the drive then running the backup script.
> I was wondering if anyone else had a better solution for crossing the
> domain security barrier.
> Thanks!
>|||Create a share on the remote server and then use unc path for the
destination.
e.g.
backup database <db>
to disk='\\remoteserver\shared\db.bak'
-oj

> <outoftherealm@.hotmail.com> wrote in message
> news:1143475970.853389.244620@.u72g2000cwu.googlegroups.com...
>|||If you dont want to create a permanent share then you can use
net use <drive name>: <unc path> user:<user name with doamin> password
ex
net use P: \\10.10.10.10\folder /user:mydomain\username password.
Run this job as first step and if is success take backup to mapped
drive.
Regards
Amish Shah|||how to set username and password
when server run with local system service?
mydomain\username and password don't work or
server is in workgroup (not in domain)
Thanks
"amish" <shahamishm@.gmail.com> wrote in message
news:1143559961.804068.209860@.t31g2000cwb.googlegroups.com...
> If you dont want to create a permanent share then you can use
> net use <drive name>: <unc path> user:<user name with doamin> password
> ex
> net use P: \\10.10.10.10\folder /user:mydomain\username password.
> Run this job as first step and if is success take backup to mapped
> drive.
>
> Regards
> Amish Shah
>

Friday, February 10, 2012

Backup to Storage Server in another domain.

I am attempting to use enterprise manager to backup databases to a
storage server in another domain and was looking for some advice.
Currently the server is running small business server so I cannot
create a trust to the storage servers domain.
I created a mapped drive when logged in as the sql service account but
this did not work.
I was thinking about making a job that used the net use command to
create the drive then running the backup script.
I was wondering if anyone else had a better solution for crossing the
domain security barrier.
Thanks!Hi
I have my doubt that you have by EM backup database on remote computer.
BACKUP DATABASE db TO DISK = N'\\ServerName\backup\db.BAK'
--
exec SRV003.master.dbo.sp_executesql N'BACKUP DATABASE pubs
to DISK =''d:\Program Files\Microsoft SQL
Server\MSSQL$BELLTOWER\BACKUP\testback.bak'''
exec SRV003.master.dbo.sp_executesql
N'BACKUP DATABASE pubs to testback'
<outoftherealm@.hotmail.com> wrote in message
news:1143475970.853389.244620@.u72g2000cwu.googlegroups.com...
>I am attempting to use enterprise manager to backup databases to a
> storage server in another domain and was looking for some advice.
> Currently the server is running small business server so I cannot
> create a trust to the storage servers domain.
> I created a mapped drive when logged in as the sql service account but
> this did not work.
> I was thinking about making a job that used the net use command to
> create the drive then running the backup script.
> I was wondering if anyone else had a better solution for crossing the
> domain security barrier.
> Thanks!
>|||Create a share on the remote server and then use unc path for the
destination.
e.g.
backup database <db>
to disk='\\remoteserver\shared\db.bak'
-oj
> <outoftherealm@.hotmail.com> wrote in message
> news:1143475970.853389.244620@.u72g2000cwu.googlegroups.com...
>>I am attempting to use enterprise manager to backup databases to a
>> storage server in another domain and was looking for some advice.
>> Currently the server is running small business server so I cannot
>> create a trust to the storage servers domain.
>> I created a mapped drive when logged in as the sql service account but
>> this did not work.
>> I was thinking about making a job that used the net use command to
>> create the drive then running the backup script.
>> I was wondering if anyone else had a better solution for crossing the
>> domain security barrier.
>> Thanks!
>|||If you dont want to create a permanent share then you can use
net use <drive name>: <unc path> user:<user name with doamin> password
ex
net use P: \\10.10.10.10\folder /user:mydomain\username password.
Run this job as first step and if is success take backup to mapped
drive.
Regards
Amish Shah|||how to set username and password
when server run with local system service?
mydomain\username and password don't work or
server is in workgroup (not in domain)
Thanks
"amish" <shahamishm@.gmail.com> wrote in message
news:1143559961.804068.209860@.t31g2000cwb.googlegroups.com...
> If you dont want to create a permanent share then you can use
> net use <drive name>: <unc path> user:<user name with doamin> password
> ex
> net use P: \\10.10.10.10\folder /user:mydomain\username password.
> Run this job as first step and if is success take backup to mapped
> drive.
>
> Regards
> Amish Shah
>

Backup to Network Drive

We are attempting to set our SQL Server 2000 backups to point to a network
drive. We have created a domain user and set the SQL Server Service and SQL
Server Agent to use this account. We have also set this account as a member
of the Administrators group on the SQL Server itself and added it to the sys
admin group within SQL Server. On the destination server, the service account
has full control on the share that we'd like to write to. Unfortunately, our
backups are failing. The SQL Server Log provides the following message
"BackupDiskFile::CreateMedia: Backup device '\\Server\SQLBackup' failed to
create. Operating system error = 5(Access is denied.)."
What are we missing here?Marcia,
Did you restart the SQL Server once the drive was mounted on your
server? Have you verified that as the user which SQL Server starts
under on the box you can read and write data to that location? These
are some of the gotcha's. I wish SQL Server allowed you to see network
mount points when you go to Backup Database options through Enterprise
Manager.
Shahryar
MarciaN wrote:
>We are attempting to set our SQL Server 2000 backups to point to a network
>drive. We have created a domain user and set the SQL Server Service and SQL
>Server Agent to use this account. We have also set this account as a member
>of the Administrators group on the SQL Server itself and added it to the sys
>admin group within SQL Server. On the destination server, the service account
>has full control on the share that we'd like to write to. Unfortunately, our
>backups are failing. The SQL Server Log provides the following message
>"BackupDiskFile::CreateMedia: Backup device '\\Server\SQLBackup' failed to
>create. Operating system error = 5(Access is denied.)."
>What are we missing here?
>
Shahryar G. Hashemi | Sr. DBA Consultant
InfoSpace, Inc.
601 108th Ave NE | Suite 1200 | Bellevue, WA 98004 USA
Mobile +1 206.459.6203 | Office +1 425.201.8853 | Fax +1 425.201.6150
shashem@.infospace.com | www.infospaceinc.com
This e-mail and any attachments may contain confidential information that is legally privileged. The information is solely for the use of the intended recipient(s); any disclosure, copying, distribution, or other use of this information is strictly prohibited. If you have received this e-mail in error, please notify the sender by return e-mail and delete this message. Thank you.|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/?kbid=555128
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"MarciaN" <MarciaN@.discussions.microsoft.com> wrote in message
news:B8AAEF33-2B4B-445A-ADBF-F2D74A78F0D2@.microsoft.com...
> We are attempting to set our SQL Server 2000 backups to point to a network
> drive. We have created a domain user and set the SQL Server Service and
> SQL
> Server Agent to use this account. We have also set this account as a
> member
> of the Administrators group on the SQL Server itself and added it to the
> sys
> admin group within SQL Server. On the destination server, the service
> account
> has full control on the share that we'd like to write to. Unfortunately,
> our
> backups are failing. The SQL Server Log provides the following message
> "BackupDiskFile::CreateMedia: Backup device '\\Server\SQLBackup' failed to
> create. Operating system error = 5(Access is denied.)."
> What are we missing here?|||We have followed these procedures and still no luck. Can you give some
specifics related to the access levels that the WIndows Service account
should have?
"Geoff N. Hiten" wrote:
> HowTo: Backup to UNC name using Database Maintenance Wizard
> http://support.microsoft.com/?kbid=555128
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "MarciaN" <MarciaN@.discussions.microsoft.com> wrote in message
> news:B8AAEF33-2B4B-445A-ADBF-F2D74A78F0D2@.microsoft.com...
> > We are attempting to set our SQL Server 2000 backups to point to a network
> > drive. We have created a domain user and set the SQL Server Service and
> > SQL
> > Server Agent to use this account. We have also set this account as a
> > member
> > of the Administrators group on the SQL Server itself and added it to the
> > sys
> > admin group within SQL Server. On the destination server, the service
> > account
> > has full control on the share that we'd like to write to. Unfortunately,
> > our
> > backups are failing. The SQL Server Log provides the following message
> > "BackupDiskFile::CreateMedia: Backup device '\\Server\SQLBackup' failed to
> > create. Operating system error = 5(Access is denied.)."
> >
> > What are we missing here?
>
>|||The SQL Server service account requires FULL CONTROL over the share and the
underlying NTFS directory structure.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"MarciaN" <MarciaN@.discussions.microsoft.com> wrote in message
news:12B2D6D3-3FFF-4356-9857-700A5E2CF2F0@.microsoft.com...
> We have followed these procedures and still no luck. Can you give some
> specifics related to the access levels that the WIndows Service account
> should have?
>
> "Geoff N. Hiten" wrote:
>> HowTo: Backup to UNC name using Database Maintenance Wizard
>> http://support.microsoft.com/?kbid=555128
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>> "MarciaN" <MarciaN@.discussions.microsoft.com> wrote in message
>> news:B8AAEF33-2B4B-445A-ADBF-F2D74A78F0D2@.microsoft.com...
>> > We are attempting to set our SQL Server 2000 backups to point to a
>> > network
>> > drive. We have created a domain user and set the SQL Server Service and
>> > SQL
>> > Server Agent to use this account. We have also set this account as a
>> > member
>> > of the Administrators group on the SQL Server itself and added it to
>> > the
>> > sys
>> > admin group within SQL Server. On the destination server, the service
>> > account
>> > has full control on the share that we'd like to write to.
>> > Unfortunately,
>> > our
>> > backups are failing. The SQL Server Log provides the following message
>> > "BackupDiskFile::CreateMedia: Backup device '\\Server\SQLBackup' failed
>> > to
>> > create. Operating system error = 5(Access is denied.)."
>> >
>> > What are we missing here?
>>|||We gave the service account FULL CONTROL over the share. After an
unsuccessful test of that, we added the service account to the local admins
group on the destination server and still no luck. It seems like we have
covered all the bases but still can not make this work. Can you think of
anything else?
"Geoff N. Hiten" wrote:
> The SQL Server service account requires FULL CONTROL over the share and the
> underlying NTFS directory structure.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "MarciaN" <MarciaN@.discussions.microsoft.com> wrote in message
> news:12B2D6D3-3FFF-4356-9857-700A5E2CF2F0@.microsoft.com...
> > We have followed these procedures and still no luck. Can you give some
> > specifics related to the access levels that the WIndows Service account
> > should have?
> >
> >
> > "Geoff N. Hiten" wrote:
> >
> >> HowTo: Backup to UNC name using Database Maintenance Wizard
> >> http://support.microsoft.com/?kbid=555128
> >>
> >> --
> >> Geoff N. Hiten
> >> Senior Database Administrator
> >> Microsoft SQL Server MVP
> >> "MarciaN" <MarciaN@.discussions.microsoft.com> wrote in message
> >> news:B8AAEF33-2B4B-445A-ADBF-F2D74A78F0D2@.microsoft.com...
> >> > We are attempting to set our SQL Server 2000 backups to point to a
> >> > network
> >> > drive. We have created a domain user and set the SQL Server Service and
> >> > SQL
> >> > Server Agent to use this account. We have also set this account as a
> >> > member
> >> > of the Administrators group on the SQL Server itself and added it to
> >> > the
> >> > sys
> >> > admin group within SQL Server. On the destination server, the service
> >> > account
> >> > has full control on the share that we'd like to write to.
> >> > Unfortunately,
> >> > our
> >> > backups are failing. The SQL Server Log provides the following message
> >> > "BackupDiskFile::CreateMedia: Backup device '\\Server\SQLBackup' failed
> >> > to
> >> > create. Operating system error = 5(Access is denied.)."
> >> >
> >> > What are we missing here?
> >>
> >>
> >>
>
>|||Verify NTFS file permissions on the destination directory. This is
different from the share security permissions.
Log in to the console of the SQL Server as the service account and try to
access the network share directly. Create, rename, and delete a file.
Run a backup via Query Analyzer (BACKUP DATABASE command) to the share
location.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"MarciaN" <MarciaN@.discussions.microsoft.com> wrote in message
news:3469833A-EC8A-4755-828B-D309A0A2F72E@.microsoft.com...
> We gave the service account FULL CONTROL over the share. After an
> unsuccessful test of that, we added the service account to the local
> admins
> group on the destination server and still no luck. It seems like we have
> covered all the bases but still can not make this work. Can you think of
> anything else?
> "Geoff N. Hiten" wrote:
>> The SQL Server service account requires FULL CONTROL over the share and
>> the
>> underlying NTFS directory structure.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>> "MarciaN" <MarciaN@.discussions.microsoft.com> wrote in message
>> news:12B2D6D3-3FFF-4356-9857-700A5E2CF2F0@.microsoft.com...
>> > We have followed these procedures and still no luck. Can you give some
>> > specifics related to the access levels that the WIndows Service account
>> > should have?
>> >
>> >
>> > "Geoff N. Hiten" wrote:
>> >
>> >> HowTo: Backup to UNC name using Database Maintenance Wizard
>> >> http://support.microsoft.com/?kbid=555128
>> >>
>> >> --
>> >> Geoff N. Hiten
>> >> Senior Database Administrator
>> >> Microsoft SQL Server MVP
>> >> "MarciaN" <MarciaN@.discussions.microsoft.com> wrote in message
>> >> news:B8AAEF33-2B4B-445A-ADBF-F2D74A78F0D2@.microsoft.com...
>> >> > We are attempting to set our SQL Server 2000 backups to point to a
>> >> > network
>> >> > drive. We have created a domain user and set the SQL Server Service
>> >> > and
>> >> > SQL
>> >> > Server Agent to use this account. We have also set this account as a
>> >> > member
>> >> > of the Administrators group on the SQL Server itself and added it to
>> >> > the
>> >> > sys
>> >> > admin group within SQL Server. On the destination server, the
>> >> > service
>> >> > account
>> >> > has full control on the share that we'd like to write to.
>> >> > Unfortunately,
>> >> > our
>> >> > backups are failing. The SQL Server Log provides the following
>> >> > message
>> >> > "BackupDiskFile::CreateMedia: Backup device '\\Server\SQLBackup'
>> >> > failed
>> >> > to
>> >> > create. Operating system error = 5(Access is denied.)."
>> >> >
>> >> > What are we missing here?
>> >>
>> >>
>> >>
>>|||I'd start by logging in on the SQL Server machine using the service account and see if I can access
and create files. If so, use xp_cmdshell to see if you can do the same.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"MarciaN" <MarciaN@.discussions.microsoft.com> wrote in message
news:3469833A-EC8A-4755-828B-D309A0A2F72E@.microsoft.com...
> We gave the service account FULL CONTROL over the share. After an
> unsuccessful test of that, we added the service account to the local admins
> group on the destination server and still no luck. It seems like we have
> covered all the bases but still can not make this work. Can you think of
> anything else?
> "Geoff N. Hiten" wrote:
>> The SQL Server service account requires FULL CONTROL over the share and the
>> underlying NTFS directory structure.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>> "MarciaN" <MarciaN@.discussions.microsoft.com> wrote in message
>> news:12B2D6D3-3FFF-4356-9857-700A5E2CF2F0@.microsoft.com...
>> > We have followed these procedures and still no luck. Can you give some
>> > specifics related to the access levels that the WIndows Service account
>> > should have?
>> >
>> >
>> > "Geoff N. Hiten" wrote:
>> >
>> >> HowTo: Backup to UNC name using Database Maintenance Wizard
>> >> http://support.microsoft.com/?kbid=555128
>> >>
>> >> --
>> >> Geoff N. Hiten
>> >> Senior Database Administrator
>> >> Microsoft SQL Server MVP
>> >> "MarciaN" <MarciaN@.discussions.microsoft.com> wrote in message
>> >> news:B8AAEF33-2B4B-445A-ADBF-F2D74A78F0D2@.microsoft.com...
>> >> > We are attempting to set our SQL Server 2000 backups to point to a
>> >> > network
>> >> > drive. We have created a domain user and set the SQL Server Service and
>> >> > SQL
>> >> > Server Agent to use this account. We have also set this account as a
>> >> > member
>> >> > of the Administrators group on the SQL Server itself and added it to
>> >> > the
>> >> > sys
>> >> > admin group within SQL Server. On the destination server, the service
>> >> > account
>> >> > has full control on the share that we'd like to write to.
>> >> > Unfortunately,
>> >> > our
>> >> > backups are failing. The SQL Server Log provides the following message
>> >> > "BackupDiskFile::CreateMedia: Backup device '\\Server\SQLBackup' failed
>> >> > to
>> >> > create. Operating system error = 5(Access is denied.)."
>> >> >
>> >> > What are we missing here?
>> >>
>> >>
>> >>
>>|||It's working! We deleted the shared folder and recreated it. Now it works.
Thanks to all for your suggestions.
"Tibor Karaszi" wrote:
> I'd start by logging in on the SQL Server machine using the service account and see if I can access
> and create files. If so, use xp_cmdshell to see if you can do the same.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "MarciaN" <MarciaN@.discussions.microsoft.com> wrote in message
> news:3469833A-EC8A-4755-828B-D309A0A2F72E@.microsoft.com...
> > We gave the service account FULL CONTROL over the share. After an
> > unsuccessful test of that, we added the service account to the local admins
> > group on the destination server and still no luck. It seems like we have
> > covered all the bases but still can not make this work. Can you think of
> > anything else?
> >
> > "Geoff N. Hiten" wrote:
> >
> >> The SQL Server service account requires FULL CONTROL over the share and the
> >> underlying NTFS directory structure.
> >>
> >> --
> >> Geoff N. Hiten
> >> Senior Database Administrator
> >> Microsoft SQL Server MVP
> >>
> >> "MarciaN" <MarciaN@.discussions.microsoft.com> wrote in message
> >> news:12B2D6D3-3FFF-4356-9857-700A5E2CF2F0@.microsoft.com...
> >> > We have followed these procedures and still no luck. Can you give some
> >> > specifics related to the access levels that the WIndows Service account
> >> > should have?
> >> >
> >> >
> >> > "Geoff N. Hiten" wrote:
> >> >
> >> >> HowTo: Backup to UNC name using Database Maintenance Wizard
> >> >> http://support.microsoft.com/?kbid=555128
> >> >>
> >> >> --
> >> >> Geoff N. Hiten
> >> >> Senior Database Administrator
> >> >> Microsoft SQL Server MVP
> >> >> "MarciaN" <MarciaN@.discussions.microsoft.com> wrote in message
> >> >> news:B8AAEF33-2B4B-445A-ADBF-F2D74A78F0D2@.microsoft.com...
> >> >> > We are attempting to set our SQL Server 2000 backups to point to a
> >> >> > network
> >> >> > drive. We have created a domain user and set the SQL Server Service and
> >> >> > SQL
> >> >> > Server Agent to use this account. We have also set this account as a
> >> >> > member
> >> >> > of the Administrators group on the SQL Server itself and added it to
> >> >> > the
> >> >> > sys
> >> >> > admin group within SQL Server. On the destination server, the service
> >> >> > account
> >> >> > has full control on the share that we'd like to write to.
> >> >> > Unfortunately,
> >> >> > our
> >> >> > backups are failing. The SQL Server Log provides the following message
> >> >> > "BackupDiskFile::CreateMedia: Backup device '\\Server\SQLBackup' failed
> >> >> > to
> >> >> > create. Operating system error = 5(Access is denied.)."
> >> >> >
> >> >> > What are we missing here?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>|||Windows has two level access control.
You need to give the sql account first the access to the shared
drive/directory and then you need to give access to the
files
1. Access to the SHARE
2. Access to files on that share
1. On the shared directory right click-> sharing->permissions. Check the
SQL account has access rights.
2. same right click->security->permissions. check the SQL account has
rights.
That should do it
rgrds Matti

Backup to Network Drive

Backup to Location over VPN

Hi,
I am having problems with creating a backup onto a machine that is connected to the domain via a VPN connection.
When i do the back up it does not recognize the directory that I have specified, yet when i use Windows explorer I can copy and paste to my hearts content.
I was just wondering if the backup of a database can be done to a location over a VPN.
Thanks in Advance
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Backups are done under the account that SQL Server runs under, not the
account you are using when you log in to QA or EM. SQL Server is most
likely running under the local service account which knows nothing of the
VPN or the Domain.
Andrew J. Kelly SQL MVP
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uhIiucxbEHA.252@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am having problems with creating a backup onto a machine that is
connected to the domain via a VPN connection.
> When i do the back up it does not recognize the directory that I have
specified, yet when i use Windows explorer I can copy and paste to my hearts
content.
> I was just wondering if the backup of a database can be done to a location
over a VPN.
> Thanks in Advance
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.

Backup to Location over VPN

Hi,
I am having problems with creating a backup onto a machine that is connected
to the domain via a VPN connection.
When i do the back up it does not recognize the directory that I have specif
ied, yet when i use Windows explorer I can copy and paste to my hearts conte
nt.
I was just wondering if the backup of a database can be done to a location o
ver a VPN.
Thanks in Advance
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.Backups are done under the account that SQL Server runs under, not the
account you are using when you log in to QA or EM. SQL Server is most
likely running under the local service account which knows nothing of the
VPN or the Domain.
Andrew J. Kelly SQL MVP
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uhIiucxbEHA.252@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am having problems with creating a backup onto a machine that is
connected to the domain via a VPN connection.
> When i do the back up it does not recognize the directory that I have
specified, yet when i use Windows explorer I can copy and paste to my hearts
content.
> I was just wondering if the backup of a database can be done to a location
over a VPN.
> Thanks in Advance
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.

Wednesday, March 7, 2012

backups failing

backups failing

Sunday, February 19, 2012

Backup/Restore MSSQL database from domain host?

Backup/Restore MSSQL database from domain host?

Monday, February 13, 2012

Backup w/RETAINDAYS just keeps growin', and growin'

Sunday, February 12, 2012

Backup to USB drive failing

Backup to USB drive failing

Backup to Storage Server in another domain.

Backup to Storage Server in another domain.

Friday, February 10, 2012

Backup to Storage Server in another domain.

Backup to Network Drive

Backup to Network Drive

Backup to Network Drive

Backup to Location over VPN

Backup to Location over VPN

Backup to Network Drive

Blog Archive

About Me