There are 5 different database state are there, they are – Online: Available for all users. Offline: Unavailable. Restoring: Unavailable…
What will happen if model database get corrupted ?
If model database gets corrupted, then SQL server services not started because whenever SQL server is started tempdb is created…
How to attach a database.
T-SQL USE [master] GO CREATE DATABASE [AdventureWorks2008] ON ( FILENAME = N’D:\AdventureWorks2008_Database\AdventureWorks2008_Data.mdf’ ), ( FILENAME = N’D:\AdventureWorks2008_Database\AdventureWorks2008_Log.ldf’ ) FOR ATTACH…
Your database log drive got full. how you will recover it.
First we have to run “dbcc sqlperf(logspace)” from there we get “Log Size” and “Log Space Used“. If log size…