Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
 Posted - 2009-03-15 : 21:36:34
|
| Hi,Due to some issue we rebuild our SQL SERVER 2005 DB.We installed OS and sql server,then attached db.Restore master and msdb database from old backup.I've seen all jobs but all jobs are failing.Could you guys please suggest?Job description:Backup Database [pact] TO [pact] WITH INIT, NOUNLOAD, Name = N'Impact Full backup With Init', SKIP, STATS = 10, NOFORMAT; EXEC sp_MSforeachtable @command1 = "sp_recompile '?'"How to find what is the location of pact Database?All backup has been setup like similar to.Which table I use to see backup details?Please advice. |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-03-16 : 03:43:14
|
quote:
Originally posted by sqlserverdbam
Hi,Due to some issue we rebuild our SQL SERVER 2005 DB.We installed OS and sql server,then attached db.Restore master and msdb database from old backup.I've seen all jobs but all jobs are failing.Could you guys please suggest?Job description:Backup Database [pact] TO [pact] WITH INIT, NOUNLOAD, Name = N'Impact Full backup With Init', SKIP, STATS = 10, NOFORMAT; EXEC sp_MSforeachtable @command1 = "sp_recompile '?'"How to find what is the location of pact Database?All backup has been setup like similar to.Which table I use to see backup details?Please advice.
Here is BOL link listing system tables for backup metadata.[url]ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/aa615add-54e6-40f5-8b55-3728b26884ee.htm[/url]u can also use sys.backup_devices to get details about the backup deviceRegards,Ahmad Osama |
 |
|
|
|
|
|
|
|
Job failing after msdb restore