Article to manage SQL Server 2000 transaction log growth http://www.mssqltips.com/tip.asp?tip=950 Advertisements
Category: Backup
DBCC CHECKDB
How to see backup history through the back-end?
By querying msdb.dbo.backupset and msdb.obackupmediafamily one can see backup history like start and end time, type of backup, location of … More
How to create differential backup?
Using the following T-SQL one can create differential backup or make it part of scheduled job. declare @datetimestamp varchar(20) declare … More
