Backup restore fail

Hi,
I am trying to restore database (25 GB) and getting
following error
The backup data in 'F:\BACKUP\ABC.BAK' is incorrectly
formatted. Backups cannot be appended, but existing backup
sets may still be usable.
Has any one solution for this ?
Thanks,
ManojHi Manoj,
This error normally occurs when the filemark in the backup device could not
be read.
The various reasons for this error can be,
1. A media failure on the device where the backup is located.
2. A write failure during the creation of the backup. Eg: Network failre
during a network backup
Solution:
This error normally comes if any one of the file in backup set is
problematic. It might be possible to retrieve other backup sets
from the device by specifying the file number
You can use the RESTORE HEADERONLY command to idenfify the backup file list
and use RESTORE DATABASE to restore the specific file.
Sample code
RESTORE HEADERONLY FROM DISK='c:\backup\dbname.bak'
RESTORE DATABASE mydatabase FROM DISK='C:\backup\dbname.bak' WITH FILE =
FileNumber
Have a look into this article,
http://support.microsoft.com/defaul...b;en-us;Q290787
Thanks
Hari
MCDBA
"Manoj" <manoj_raheja@.hotmail.com> wrote in message
news:4d8e01c3ff6e$f2f3df60$a101280a@.phx.gbl...
> Hi,
> I am trying to restore database (25 GB) and getting
> following error
> The backup data in 'F:\BACKUP\ABC.BAK' is incorrectly
> formatted. Backups cannot be appended, but existing backup
> sets may still be usable.
> Has any one solution for this ?
> Thanks,
> Manojsql

Backup restore fail

Hi,
I am trying to restore database (25 GB) and getting
following error
The backup data in 'F:\BACKUP\ABC.BAK' is incorrectly
formatted. Backups cannot be appended, but existing backup
sets may still be usable.
Has any one solution for this ?
Thanks,
ManojHi Manoj,
This error normally occurs when the filemark in the backup device could not
be read.
The various reasons for this error can be,
1. A media failure on the device where the backup is located.
2. A write failure during the creation of the backup. Eg: Network failre
during a network backup
Solution:
This error normally comes if any one of the file in backup set is
problematic. It might be possible to retrieve other backup sets
from the device by specifying the file number
You can use the RESTORE HEADERONLY command to idenfify the backup file list
and use RESTORE DATABASE to restore the specific file.
Sample code
RESTORE HEADERONLY FROM DISK='c:\backup\dbname.bak'
RESTORE DATABASE mydatabase FROM DISK='C:\backup\dbname.bak' WITH FILE =FileNumber
Have a look into this article,
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q290787
Thanks
Hari
MCDBA
"Manoj" <manoj_raheja@.hotmail.com> wrote in message
news:4d8e01c3ff6e$f2f3df60$a101280a@.phx.gbl...
> Hi,
> I am trying to restore database (25 GB) and getting
> following error
> The backup data in 'F:\BACKUP\ABC.BAK' is incorrectly
> formatted. Backups cannot be appended, but existing backup
> sets may still be usable.
> Has any one solution for this ?
> Thanks,
> Manoj

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
__Stephen
No, 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 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 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 operation/job fail information

Hi,
I would like to know about the internal information regarding sql backup
operation.
I want to monitor the Backup operation in all version of sql server. I am
able to get all the information from the msdb database but i'll not find any
information regarding backup fails.
Suppose i want to monitor a database in a certain time interval and i want
to collect data for successful backup and failed backup.
How do i collect these information through my code?
Should i read and parse Error log file or sql provide some system table or
stored procedure for this?
Or there are any api provided by sql?
I'm waiting for positive response.
Thanks n Regards,
Nikhil Kumar JainHi
Yes , Error Log should give you an info.
"Nikhil Kumar Jain" <NikhilKumarJain@.discussions.microsoft.com> wrote in
message news:B0074C50-F6B0-4370-B95A-8A8C7E7DB0AD@.microsoft.com...
> Hi,
> I would like to know about the internal information regarding sql backup
> operation.
> I want to monitor the Backup operation in all version of sql server. I am
> able to get all the information from the msdb database but i'll not find
> any
> information regarding backup fails.
> Suppose i want to monitor a database in a certain time interval and i want
> to collect data for successful backup and failed backup.
> How do i collect these information through my code?
> Should i read and parse Error log file or sql provide some system table or
> stored procedure for this?
> Or there are any api provided by sql?
> I'm waiting for positive response.
> Thanks n Regards,
> Nikhil Kumar Jain

BACKUP LOG failed - no reason given

Hello,
I have an agent job that backs up transaction logs of several databases,
referring a maintenance plan.
Recently, one of the backups began to fail sometimes - the one of the
largest database. The messages in the log are:
...
Log backed up: Database: OLAP, creation date(time): 2004/01/21(11:42:56),
first LSN: 4615:16:1, last LSN: 4617:16:1, number of dump devices: 1, device
information: (FILE=1, TYPE=DISK:
{'D:\MSSQL\MSSQL\BACKUP\OLAP_tlog_200501211015.TRN '}).
Log backed up: Database: RGRSQL, creation date(time): 2004/01/08(10:20:44),
first LSN: 50593:45:1, last LSN: 50614:57:1, number of dump devices: 1,
device information: (FILE=1, TYPE=DISK:
{'D:\MSSQL\MSSQL\BACKUP\RGRSQL_tlog_200501211015.T RN'}).
BACKUP failed to complete the command BACKUP LOG [VMFG] TO DISK =
N'D:\MSSQL\MSSQL\BACKUP\VMFG_tlog_200501211015.TRN ' WITH INIT , NOUNLOAD ,
NOSKIP , STATS = 10, NOFORMAT
MSKB article says to examine the previous errors in the log, but there are
none, neither in sql server log, nor in any event log of the machine.
And then on the next scheduled time, it succeeds. Then again fails. No
pattern.
Pretty much same thing is happening with the full database backup - same
database.
"CHECKDB found 0 allocation errors and 0 consistency errors in database
'VMFG'."
How to troubleshoot it? is there a way to make it to tell _why_ it failed?
thanks,
Vadim Rapp
Polyscience, Inc.
Is someone else trying to put your backup device onto tape while your trying
to write to it?
"Vadim Rapp" <vrapp@.nospam.polyscience.com> wrote in message
news:#6Hq$J#$EHA.2316@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have an agent job that backs up transaction logs of several databases,
> referring a maintenance plan.
> Recently, one of the backups began to fail sometimes - the one of the
> largest database. The messages in the log are:
> ...
> Log backed up: Database: OLAP, creation date(time): 2004/01/21(11:42:56),
> first LSN: 4615:16:1, last LSN: 4617:16:1, number of dump devices: 1,
device
> information: (FILE=1, TYPE=DISK:
> {'D:\MSSQL\MSSQL\BACKUP\OLAP_tlog_200501211015.TRN '}).
> Log backed up: Database: RGRSQL, creation date(time):
2004/01/08(10:20:44),
> first LSN: 50593:45:1, last LSN: 50614:57:1, number of dump devices: 1,
> device information: (FILE=1, TYPE=DISK:
> {'D:\MSSQL\MSSQL\BACKUP\RGRSQL_tlog_200501211015.T RN'}).
> BACKUP failed to complete the command BACKUP LOG [VMFG] TO DISK =
> N'D:\MSSQL\MSSQL\BACKUP\VMFG_tlog_200501211015.TRN ' WITH INIT , NOUNLOAD
,
> NOSKIP , STATS = 10, NOFORMAT
> MSKB article says to examine the previous errors in the log, but there are
> none, neither in sql server log, nor in any event log of the machine.
> And then on the next scheduled time, it succeeds. Then again fails. No
> pattern.
> Pretty much same thing is happening with the full database backup - same
> database.
> "CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'VMFG'."
> How to troubleshoot it? is there a way to make it to tell _why_ it failed?
>
> thanks,
> Vadim Rapp
> Polyscience, Inc.
>
>
|||Hello Chris:
You wrote on Fri, 21 Jan 2005 11:09:20 -0800:
C> Is someone else trying to put your backup device onto tape while your
C> trying to write to it?
No.
Vadim

BACKUP LOG failed - no reason given

Hello,
I have an agent job that backs up transaction logs of several databases,
referring a maintenance plan.
Recently, one of the backups began to fail sometimes - the one of the
largest database. The messages in the log are:
...
Log backed up: Database: OLAP, creation date(time): 2004/01/21(11:42:56),
first LSN: 4615:16:1, last LSN: 4617:16:1, number of dump devices: 1, device
information: (FILE=1, TYPE=DISK:
& #123;'D:\MSSQL\MSSQL\BACKUP\OLAP_tlog_20
0501211015.TRN'}).
Log backed up: Database: RGRSQL, creation date(time): 2004/01/08(10:20:44),
first LSN: 50593:45:1, last LSN: 50614:57:1, number of dump devices: 1,
device information: (FILE=1, TYPE=DISK:
& #123;'D:\MSSQL\MSSQL\BACKUP\RGRSQL_tlog_
200501211015.TRN'}).
BACKUP failed to complete the command BACKUP LOG [VMFG] TO DISK =
N'D:\MSSQL\MSSQL\BACKUP\VMFG_tlog_200501
211015.TRN' WITH INIT , NOUNLOAD ,
NOSKIP , STATS = 10, NOFORMAT
MSKB article says to examine the previous errors in the log, but there are
none, neither in sql server log, nor in any event log of the machine.
And then on the next scheduled time, it succeeds. Then again fails. No
pattern.
Pretty much same thing is happening with the full database backup - same
database.
"CHECKDB found 0 allocation errors and 0 consistency errors in database
'VMFG'."
How to troubleshoot it? is there a way to make it to tell _why_ it failed?
thanks,
Vadim Rapp
Polyscience, Inc.Is someone else trying to put your backup device onto tape while your trying
to write to it?
"Vadim Rapp" <vrapp@.nospam.polyscience.com> wrote in message
news:#6Hq$J#$EHA.2316@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have an agent job that backs up transaction logs of several databases,
> referring a maintenance plan.
> Recently, one of the backups began to fail sometimes - the one of the
> largest database. The messages in the log are:
> ...
> Log backed up: Database: OLAP, creation date(time): 2004/01/21(11:42:56),
> first LSN: 4615:16:1, last LSN: 4617:16:1, number of dump devices: 1,
device
> information: (FILE=1, TYPE=DISK:
> & #123;'D:\MSSQL\MSSQL\BACKUP\OLAP_tlog_20
0501211015.TRN'}).
> Log backed up: Database: RGRSQL, creation date(time):
2004/01/08(10:20:44),
> first LSN: 50593:45:1, last LSN: 50614:57:1, number of dump devices: 1,
> device information: (FILE=1, TYPE=DISK:
> & #123;'D:\MSSQL\MSSQL\BACKUP\RGRSQL_tlog_
200501211015.TRN'}).
> BACKUP failed to complete the command BACKUP LOG [VMFG] TO DISK =
> N'D:\MSSQL\MSSQL\BACKUP\VMFG_tlog_200501
211015.TRN' WITH INIT , NOUNLOAD
,
> NOSKIP , STATS = 10, NOFORMAT
> MSKB article says to examine the previous errors in the log, but there are
> none, neither in sql server log, nor in any event log of the machine.
> And then on the next scheduled time, it succeeds. Then again fails. No
> pattern.
> Pretty much same thing is happening with the full database backup - same
> database.
> "CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'VMFG'."
> How to troubleshoot it? is there a way to make it to tell _why_ it failed?
>
> thanks,
> Vadim Rapp
> Polyscience, Inc.
>
>|||Hello Chris:
You wrote on Fri, 21 Jan 2005 11:09:20 -0800:
C> Is someone else trying to put your backup device onto tape while your
C> trying to write to it?
No.
Vadim

Backup issuesPlease HEELP!

I am trying to run a backup job and it has fail the message I am getting is:

The job failed. Unable to determine if the owner (MAMSI\lwilliams) of job DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1' has server access (reason: Could not obtain information about Windows NT group/user 'MAMSI\lwilliams'. [SQLSTATE 42000] (Error 8198)).

Is it stating that my user group in windows NT doesn't have the rights to run a backup on this server?

Please help!!!

LystraMy first guess would be that the account used to start the SQL Agent service isn't a domain admin, so the agent can't even see what permissions the MAMSI\lwilliams login has in the domain.

NT security is a tough nut to crack at first, mostly because there are so many levels to it. This makes it robust, but a bugger to figure out at first!

-PatP