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 |
|
V.V.
Starting Member
32 Posts |
 Posted - 2013-08-30 : 02:44:36
|
| Hi guys,I created a 3 steps job: 1) create database backup 2) restore the backup as new database 3) verifying database integrity (DBCC CHECKDB (MyDB))I've tested yesterday and it's working just fine but I want at the end of DBCC CHECKDB process to save the result into a file on server. I was looking in History and shows me only part of the message. Besides of that, I want to have them saved in that place in case of something.Can you help me on step 3?The job I've done it is for verifying the integrity of table, thing mentioned in our maintenance plan. |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-08-30 : 06:22:02
|
| http://www.mssqltips.com/sqlservertip/2325/capture-and-store-sql-server-database-integrity-history-using-dbcc-checkdb/mohammad.javeed.ahmed@gmail.com |
 |
|
|
|
|
|
DBCC CHECKDB result to file