Hi All,
Greeting,
Sql Server 7
OS: Win NT
In the sql server logs i see the below error alerts
I/O error (bad page ID) detected during read of BUF pointer = 0x11e09e80, page ptr = 0x446b4000, pageid = (0x1:0x2c78), dbid = 4, status = 0x801, file = F:\MSSQL7\DATA\msdbdata.mdf..
Error: 823, Severity: 24, State: 1
Please help me in this.
Thanks in Advance
AdilHere's one place to look: http://support.microsoft.com/kb/q281809/
Showing posts with label msdb. Show all posts
Showing posts with label msdb. Show all posts
Monday, March 19, 2012
Sunday, February 19, 2012
Backup/restore msdb to new server
SQL 2K5 SP1
Would this be the appropriate way to move maintenance plans from one server
to another? I have a tool that will sync the data in the tables between
servers for me, would this be sufficient? Are there any pitfalls between
backup/restore between 32-bit vs 64-bit versions?
Or is there server specific info there that would be broken by doing this?
TIATim
Personally I did not test it on SQL Server 2005 , it should not be a
problem in my opinion. Read in the BOL about restoring MSDB database
"Tim Greenwood" <tim_greenwood AT yahoo DOT com> wrote in message
news:uV%23YYzDFHHA.1188@.TK2MSFTNGP06.phx.gbl...
> SQL 2K5 SP1
> Would this be the appropriate way to move maintenance plans from one
> server to another? I have a tool that will sync the data in the tables
> between servers for me, would this be sufficient? Are there any pitfalls
> between backup/restore between 32-bit vs 64-bit versions?
> Or is there server specific info there that would be broken by doing this?
> TIA
>
Would this be the appropriate way to move maintenance plans from one server
to another? I have a tool that will sync the data in the tables between
servers for me, would this be sufficient? Are there any pitfalls between
backup/restore between 32-bit vs 64-bit versions?
Or is there server specific info there that would be broken by doing this?
TIATim
Personally I did not test it on SQL Server 2005 , it should not be a
problem in my opinion. Read in the BOL about restoring MSDB database
"Tim Greenwood" <tim_greenwood AT yahoo DOT com> wrote in message
news:uV%23YYzDFHHA.1188@.TK2MSFTNGP06.phx.gbl...
> SQL 2K5 SP1
> Would this be the appropriate way to move maintenance plans from one
> server to another? I have a tool that will sync the data in the tables
> between servers for me, would this be sufficient? Are there any pitfalls
> between backup/restore between 32-bit vs 64-bit versions?
> Or is there server specific info there that would be broken by doing this?
> TIA
>
Backup/Restore History Question
Hi all,
Occasionally, when I perform a RESTORE on a database,
The msdb tables are not updated properly.
The RESTORE functions normally, however when I run a query against the
BackupSet, BackupMediaFamily and RestoreHistory tables, there appear to be orphaned records in the RestoreHistory table. (eg. The RestoreHistory has a record of the restore as well as a BackupSetID value, however these values cannot be found in the BackupSet and BackupMediaFamily tables.
This is a recurring problem, however it does not happen all of the time.
Do you have any ideas?
TIA
Rick Sawtell
MCT, MCSD, MCDBA
Too many drinks I think Rick<g>. Seriously though I have not noticed this before. Is there any chance there is a job that tries to clean out the history without using sp_deletebackuphistory?
Andrew J. Kelly SQL MVP
"Rick Sawtell" <quickening@.msn.com> wrote in message news:e7q53A54EHA.1260@.TK2MSFTNGP12.phx.gbl...
Hi all,
Occasionally, when I perform a RESTORE on a database,
The msdb tables are not updated properly.
The RESTORE functions normally, however when I run a query against the
BackupSet, BackupMediaFamily and RestoreHistory tables, there appear to be orphaned records in the RestoreHistory table. (eg. The RestoreHistory has a record of the restore as well as a BackupSetID value, however these values cannot be found in the BackupSet and BackupMediaFamily tables.
This is a recurring problem, however it does not happen all of the time.
Do you have any ideas?
TIA
Rick Sawtell
MCT, MCSD, MCDBA
|||There is that possibility,
I'm still researching it however. This only happens occasionally, so it is a bit baffling.
I've got 50 or so servers in the hosted environment and only a few of them are experiencing this problem.
All the servers are the same H/W and S/W, service packs etc.
Win 2k Server, SP4, SQL 2k SP3a etc.
I'll keep you posted, meanwhile if anyone else can think of anything...
I've got jobs that run after a restore takes place which ensures that everything in these logs match up (just in case we run into problems like this. ;-))
Rick
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message news:uT3Lwr54EHA.4008@.TK2MSFTNGP15.phx.gbl...
Too many drinks I think Rick<g>. Seriously though I have not noticed this before. Is there any chance there is a job that tries to clean out the history without using sp_deletebackuphistory?
Andrew J. Kelly SQL MVP
"Rick Sawtell" <quickening@.msn.com> wrote in message news:e7q53A54EHA.1260@.TK2MSFTNGP12.phx.gbl...
Hi all,
Occasionally, when I perform a RESTORE on a database,
The msdb tables are not updated properly.
The RESTORE functions normally, however when I run a query against the
BackupSet, BackupMediaFamily and RestoreHistory tables, there appear to be orphaned records in the RestoreHistory table. (eg. The RestoreHistory has a record of the restore as well as a BackupSetID value, however these values cannot be found in the BackupSet and BackupMediaFamily tables.
This is a recurring problem, however it does not happen all of the time.
Do you have any ideas?
TIA
Rick Sawtell
MCT, MCSD, MCDBA
Occasionally, when I perform a RESTORE on a database,
The msdb tables are not updated properly.
The RESTORE functions normally, however when I run a query against the
BackupSet, BackupMediaFamily and RestoreHistory tables, there appear to be orphaned records in the RestoreHistory table. (eg. The RestoreHistory has a record of the restore as well as a BackupSetID value, however these values cannot be found in the BackupSet and BackupMediaFamily tables.
This is a recurring problem, however it does not happen all of the time.
Do you have any ideas?
TIA
Rick Sawtell
MCT, MCSD, MCDBA
Too many drinks I think Rick<g>. Seriously though I have not noticed this before. Is there any chance there is a job that tries to clean out the history without using sp_deletebackuphistory?
Andrew J. Kelly SQL MVP
"Rick Sawtell" <quickening@.msn.com> wrote in message news:e7q53A54EHA.1260@.TK2MSFTNGP12.phx.gbl...
Hi all,
Occasionally, when I perform a RESTORE on a database,
The msdb tables are not updated properly.
The RESTORE functions normally, however when I run a query against the
BackupSet, BackupMediaFamily and RestoreHistory tables, there appear to be orphaned records in the RestoreHistory table. (eg. The RestoreHistory has a record of the restore as well as a BackupSetID value, however these values cannot be found in the BackupSet and BackupMediaFamily tables.
This is a recurring problem, however it does not happen all of the time.
Do you have any ideas?
TIA
Rick Sawtell
MCT, MCSD, MCDBA
|||There is that possibility,
I'm still researching it however. This only happens occasionally, so it is a bit baffling.
I've got 50 or so servers in the hosted environment and only a few of them are experiencing this problem.
All the servers are the same H/W and S/W, service packs etc.
Win 2k Server, SP4, SQL 2k SP3a etc.
I'll keep you posted, meanwhile if anyone else can think of anything...
I've got jobs that run after a restore takes place which ensures that everything in these logs match up (just in case we run into problems like this. ;-))
Rick
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message news:uT3Lwr54EHA.4008@.TK2MSFTNGP15.phx.gbl...
Too many drinks I think Rick<g>. Seriously though I have not noticed this before. Is there any chance there is a job that tries to clean out the history without using sp_deletebackuphistory?
Andrew J. Kelly SQL MVP
"Rick Sawtell" <quickening@.msn.com> wrote in message news:e7q53A54EHA.1260@.TK2MSFTNGP12.phx.gbl...
Hi all,
Occasionally, when I perform a RESTORE on a database,
The msdb tables are not updated properly.
The RESTORE functions normally, however when I run a query against the
BackupSet, BackupMediaFamily and RestoreHistory tables, there appear to be orphaned records in the RestoreHistory table. (eg. The RestoreHistory has a record of the restore as well as a BackupSetID value, however these values cannot be found in the BackupSet and BackupMediaFamily tables.
This is a recurring problem, however it does not happen all of the time.
Do you have any ideas?
TIA
Rick Sawtell
MCT, MCSD, MCDBA
Sunday, February 12, 2012
Backup transaction log
Hi,
I have error when i backup the transaction log of master and msdb database.
I think there is an error because the model of this database is simple.
can i modify the model and write full ?
I have another question,
I have a db with 1 db file of 11Go, i have to create secondary files or not.No, you can't change the Model database.
No, you don't need to add secondary files, but it might be a good idea.
-PatP|||Are you using the enterprise manager?|||Master database doesn't allow Differential or log backups.
Post the error message that u get while backing up the transaction log for msdb.
Howdy!|||From the tool list go to shrink database; File; change shrink to transaction log. before implentation. Go out to network and very the log size. Then go back to EM and shrink log. Again go for verifaction.
Live from Dodge City USA, Washington DC|||Yes i using entreprise manager
the error i get for msdb is the following :
"La sauvegarde ne peut tre effectue sur cette base de donnes. Cette sous-tche est ignore"|||Sorry, I need to see that in English|||viola
"the safeguard cannot be carried out on this basis of data. This sub-task is ignored "
Google...yeah baby...|||Sorry, I need to see that in EnglishTo quote W.C. Fields "Go away kid, ya bother me!"
The nickel translation is something like: "That option can't be used for this database. It will be ignored."
-PatP|||Again, I'm working with lots of data. about 290,000,000 records. In the cleanup process backups of the data is most important. After each batch run I shrink the transaction log. With that amount of data soon the log will be as big as the data file. At least that's what I was running into. Please follow the instruction above.
I have error when i backup the transaction log of master and msdb database.
I think there is an error because the model of this database is simple.
can i modify the model and write full ?
I have another question,
I have a db with 1 db file of 11Go, i have to create secondary files or not.No, you can't change the Model database.
No, you don't need to add secondary files, but it might be a good idea.
-PatP|||Are you using the enterprise manager?|||Master database doesn't allow Differential or log backups.
Post the error message that u get while backing up the transaction log for msdb.
Howdy!|||From the tool list go to shrink database; File; change shrink to transaction log. before implentation. Go out to network and very the log size. Then go back to EM and shrink log. Again go for verifaction.
Live from Dodge City USA, Washington DC|||Yes i using entreprise manager
the error i get for msdb is the following :
"La sauvegarde ne peut tre effectue sur cette base de donnes. Cette sous-tche est ignore"|||Sorry, I need to see that in English|||viola
"the safeguard cannot be carried out on this basis of data. This sub-task is ignored "
Google...yeah baby...|||Sorry, I need to see that in EnglishTo quote W.C. Fields "Go away kid, ya bother me!"
The nickel translation is something like: "That option can't be used for this database. It will be ignored."
-PatP|||Again, I'm working with lots of data. about 290,000,000 records. In the cleanup process backups of the data is most important. After each batch run I shrink the transaction log. With that amount of data soon the log will be as big as the data file. At least that's what I was running into. Please follow the instruction above.
Subscribe to:
Posts (Atom)