Category Archives: MsSQL Server

Create a Full Database Backup (SQL Server) Using SQL Server Management Studio

Create a Full Database Backup (SQL Server) Using SQL Server Management Studio: ———————————————————————————————————- Recommendations As a database increases in size full database backups take more time to finish and require more storage space. Therefore, for a large database, you might … Continue reading

Posted in MsSQL Server | Tagged , | Leave a comment

MOVING MASTER, MSSQL SYSTEMRESOURSE DB PRIMARY AND LOG FILES FROM ONE DRIVE TO ANOTHER DRIVE IN THE SAME MACHINE IN MSSQL Server 2005

MOVING MASTER, MSSQL SYSTEMRESOURSE DB PRIMARY AND LOG FILES FROM ONE DRIVE TO ANOTHER DRIVE IN THE SAME MACHINE IN MSSQL Server 2005 1.Goto Start > All programs > Microsoft sq l server 2005 > Configuration Tools > sq l … Continue reading

Posted in MsSQL Server | Tagged , | Leave a comment

MS SQL SERVER – Finding Backup status

–SQL SERVER – Finding Last Backup Time for All Database SELECT sdb.Name AS DatabaseName, COALESCE(CONVERT(VARCHAR(12), MAX(bus.backup_finish_date), 101),’-‘) AS LastBackUpTime FROM sys.sysdatabases sdb LEFT OUTER JOIN msdb.dbo.backupset bus ON bus.database_name = sdb.name GROUP BY sdb.Name ——————————————————————————————- — The following T-SQL Statement … Continue reading

Posted in MsSQL Server | Tagged , | Leave a comment