Contents
How can I tell if a SQL Server database is corrupted?
Recovery – Page Verify Option This option tells the database how the page health is verified when a page is read or written. To set this from SSMS, right click on a database, and choose properties. The Database Properties window opens. On the Options page, under the Recovery section, there is the Page Verify option.
How can I check SQL Server mirroring?
To view the status of a database mirroring session
- After connecting to the principal server instance, in Object Explorer, click the server name to expand the server tree.
- Expand Databases, and select the database to be mirrored.
- Right-click the database, select Tasks, and then click Mirror.
How to recover a corrupt MSDB SQL Server database?
The following tip shows other ways to recover the msdb database: How to recover a suspect msdb database in SQL Server .. Check out System Databases Tips Category. Daniel Farina was born in Buenos Aires, Argentina. Self-educated, since childhood he showed a passion for learning. More SQL Server DBA Tips…
Why is there a trace flag on MSDB?
This trace flag prevents the instance from automatically recovering any database except master. But databases will be started and recovered when accessed, so if we want to rebuild the msdb database it is a wise to avoid connections to that database.
Is there a way to recreate MSDB database?
If you try to connect to the instance using SQL Server Management Studio you will get an error message, but you can still use SQL Server Management Studio by selecting New\\Database Engine Query, like on the next image. Now to recreate the msdb database you can use the next SQLCMD command.
How to execute instmsdb.sql script in SQLCMD?
The “-iinstmsdb.sql” parameter instructs SQLCMD to execute the instmsdb.sql script, of course you have to be in the same folder as the script. The ” ologfile.txt” option will save the output to a file named logfile.txt in the same folder.