Back up is not recognized

Question

Post reply

Back up is not recognized

Viewing 15 posts - 16 through 30 (of 32 total)

You must be logged in to reply to this topic. Login to reply

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 1

removed

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

chetanr.jain Hall of Fame Points: 3938 More actions · Answer 2

@ravi-2,

Better try to do backup from Query

Backup database <Yourdb name> to disk=<'Path of the Physical disk.bak'>

for e.g.

Backup database model to disk='C:\Model_backup.bak'

mirravi Mr or Mrs. 500 Points: 530 More actions · Answer 3

Thanks For your reply.

i ran the query, it displys an error, but done the back up successfully.

Processed 325512 pages for database 'PGCENTURION', file 'SBOEdenvaleIntegration_RSA' on file 1.

Processed 41 pages for database 'PGCENTURION', file 'SBOEdenvaleIntegration_RSA_log' on file 1.

Msg 3009, Level 16, State 1, Line 1

Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful.

BACKUP DATABASE successfully processed 325553 pages in 317.038 seconds (8.412 MB/sec).

The statement has been terminated.

Msg 824, Level 24, State 2, Line 1

SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x0; actual signature: 0xc7eda1a0). It occurred during a read of page (1:952) in database ID 4 at offset 0x00000000770000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBData.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

please help me in sorting out this problem

thanks in advance

Ravi

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 4

mirravi (8/18/2010)
Thanks For your reply.
i ran the query, it displys an error, but done the back up successfully.
Processed 325512 pages for database 'PGCENTURION', file 'SBOEdenvaleIntegration_RSA' on file 1.
Processed 41 pages for database 'PGCENTURION', file 'SBOEdenvaleIntegration_RSA_log' on file 1.
Msg 3009, Level 16, State 1, Line 1
Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful.
BACKUP DATABASE successfully processed 325553 pages in 317.038 seconds (8.412 MB/sec).
The statement has been terminated.
Msg 824, Level 24, State 2, Line 1
SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x0; actual signature: 0xc7eda1a0). It occurred during a read of page (1:952) in database ID 4 at offset 0x00000000770000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBData.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
please help me in sorting out this problem
thanks in advance
Ravi

Run DBCC CHECKDB for this database , there is some issue with this database.

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

chetanr.jain Hall of Fame Points: 3938 More actions · Answer 5

There is issue with the MSDB Database. ( must be a Torn page on disk drive where the mdf of the msdb is stored).

Run Checkdb against the database and review the outcome.

Hope that you are keeping a regular backup policy for MSDB.

mirravi Mr or Mrs. 500 Points: 530 More actions · Answer 6

thanks for the reply.

do i need to run DBCC CHECKDB onto msdb or database?

Ramji29 Hall of Fame Points: 3832 More actions · Answer 7

Yes you need to run checkd on msdb db. But make sure you've a valid backup beforehand.

mirravi Mr or Mrs. 500 Points: 530 More actions · Answer 8

hi,

When i run DBCC CHECKDB onto MSDB , the follwing error ocuured.

Msg 8967, Level 16, State 216, Line 1

An internal error occurred in DBCC that prevented further processing. Contact Customer Support Services.

DBCC results for 'msdb'.

Msg 8921, Level 16, State 1, Line 1

Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.

CHECKDB found 0 allocation errors and 0 consistency errors in database 'msdb'.

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 9

mirravi (8/18/2010)
hi,
When i run DBCC CHECKDB onto MSDB , the follwing error ocuured.
Msg 8967, Level 16, State 216, Line 1
An internal error occurred in DBCC that prevented further processing. Contact Customer Support Services.
DBCC results for 'msdb'.
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
CHECKDB found 0 allocation errors and 0 consistency errors in database 'msdb'.

try this ( if it is not produciton server/ at your risk ) or wait to comment other on my suggestion

USE [master]
GO
ALTER DATABASE [msdb] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE [msdb] SET SINGLE_USER
GO
DBCC CHECKDB (msdb, REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE [msdb] SET MULTI_USER

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 10

or in safer side , you can restore recent MSDB backup

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Ramji29 Hall of Fame Points: 3832 More actions · Answer 11

Go with what Bhuvanesh suggested... but just take a backup of msdb before doing anything.... and what abt the last backup of msdb... do you've it??

mirravi Mr or Mrs. 500 Points: 530 More actions · Answer 12

mirravi

Mr or Mrs. 500

Points: 530

August 18, 2010 at 6:29 am

#1208424

No i dont have MSDB back

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 13

mirravi (8/18/2010)
No i dont have MSDB back

take MSDB backup and

run the below script

USE [master]

GO

ALTER DATABASE [msdb] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

ALTER DATABASE [msdb] SET SINGLE_USER

GO

DBCC CHECKDB (msdb, REPAIR_ALLOW_DATA_LOSS)

GO

ALTER DATABASE [msdb] SET MULTI_USER

IS this issue on production ?

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

mirravi Mr or Mrs. 500 Points: 530 More actions · Answer 14

Its on Production , thats make me fear to run the query!!

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 15

mirravi (8/18/2010)
Its on Production , thats make me fear to run the query!!

STRANGE :w00t::w00t: , On production , you dont have MSDB backup.

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)