Backup Restore Fails

Hi,

I ran a backup procedure and BAK file created.
I moved the file to another server, tried to restore and failed with following error:
"Cannot open backup device 'C:\*****.bak'. Operating system error 5(Access is denied.)"

I checked the file on the original server and the file is accessible: I can see its content with RESTORE FILELISTONLY command.

Any clues?

Thanks,
Mark

Hello Mark

Are you using the Restore dialog to do this operation or are you using T-SQL?

Either case, ensure that the account under which SQL server service is running has access to the 'C' drive.

[Venkat]
This posting is provided "AS IS" with no warranties, and confers no rights.

Backup process lock others out of DB?

I had a backup fail on PM run because of diskspace issue. Fixed that and ran
the job this AM. It just about crippled our DB, and my web-server couldn't
get data, just time outs.
Is this normal for the DB backup to override requests for data? If so are
there other backup software packages to create a .bak file instead of EM's
jobs?
TIA
__StephenNo, its not normal...were you writing to the same disk that the datafile(s)
reside on?
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:O2wtHkv3FHA.1396@.TK2MSFTNGP12.phx.gbl...
>I had a backup fail on PM run because of diskspace issue. Fixed that and
>ran the job this AM. It just about crippled our DB, and my web-server
>couldn't get data, just time outs.
> Is this normal for the DB backup to override requests for data? If so are
> there other backup software packages to create a .bak file instead of EM's
> jobs?
> TIA
> __Stephen
>|||"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:eSJ%23IEw3FHA.696@.TK2MSFTNGP09.phx.gbl...
> No, its not normal...were you writing to the same disk that the
> datafile(s) reside on?
No I write to a separate server for all backups and transaction logs. I
didn't think it was correct either.
Actually my server was getting hammered with batch work at the time. It's
Tues. morning so lets try to batch in 20% of our weekly business. I do a
tran log backup every 15 min and the one this morning at the time things got
hairy was only 514 meg. Normally its in the 5+ meg range. So that massive
file is an indication that I'll be beating on my system hard for the next
hour or two. We are a print shop and we feed 3 Xerox doc-u-beasts doing
financial outputs and checks.

BACKUP LOG DB WITH NO_LOG

our transaction log filled and I ran:
BACKUP LOG DB WITH NO_LOG
returns this error message:
Time out occurred while waiting for buffer latch type 3
for page (1:25176642), database ID 11, object ID
1517456680, index ID 0.
Does anyone have a clue on his (SQL Server 7)?Your disk subsystem is probably overloaded and is taking too long to do the
necessary read and writes. I would stop user access if you can until you
can fix the problem.
--
Andrew J. Kelly
SQL Server MVP
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:96f101c3ea6a$f5ea93d0$a401280a@.phx.gbl...
> our transaction log filled and I ran:
> BACKUP LOG DB WITH NO_LOG
> returns this error message:
> Time out occurred while waiting for buffer latch type 3
> for page (1:25176642), database ID 11, object ID
> 1517456680, index ID 0.
> Does anyone have a clue on his (SQL Server 7)?|||I take it that this occured only once? you';ll see more error messages in
your SQL error logs. This error that you are running isnt so much a
'Trasnaction Log' issue, but more of a Disk I/O issue.A latch is a physical
lock that lets you acquire access on the page you need ot perform your
operation on. Due to some disk i/o access, you got this error whichmeans
that the command was unable to obtain a latch.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Backup files

Hi,
I have a scheduled maintenance plan for backing up my database.
I have recently ran out of space and I need to delete some old back up files.

Question:
if I make a backup of a database (full backup) if I want to restore my databse using the transaction logs I can only go back to the latest backup?
If so, why should I keep my old backup files?
Is there any way to tell sql server to overwrite backup files each time it makes a back up and is this a good idea?

thanksWhat I have done here is to have two scheduled maintenance plans for backing up. One that runs every 24 hours that overwrites every time, and a second that appends an incremental every three hours. We then store everything on tape for two weeks.

When you set up the job there is a radio button group to select overwrite or append. If you want to edit your job step change NOINIT to INIT and then the job will overwrite.

Originally posted by Sia
Hi,
I have a scheduled maintenance plan for backing up my database.
I have recently ran out of space and I need to delete some old back up files.

Question:
if I make a backup of a database (full backup) if I want to restore my databse using the transaction logs I can only go back to the latest backup?
If so, why should I keep my old backup files?
Is there any way to tell sql server to overwrite backup files each time it makes a back up and is this a good idea?

thanks