A short description of our experience with Veritas Netbackup on MS SQL Server AG Groups. This article does not give a full description of the procedure for configuring netbackup but highlights a few pitfalls which we think some people will find very useful.
2017-07-18
2,513 reads
2017-06-23
815 reads
2017-06-05
943 reads
This script will perfrom following tasks :
1. BackUp DB
2. Restore DB from BackUp File
3. Restore DB from DB
4. Create a new DB from Existing Db
It takes care of all the possible failures during these operations, while done manually.
2017-01-11 (first published: 2017-01-09)
1,490 reads
2016-12-08
953 reads
There are times when you might want to read backup/restore history information to identify a backup’s start and finish date/time, the location where the backup was written, the size of the database backup, etc. Greg Larsen shows you how to do this in SQL Server.
2016-10-31
4,425 reads
2016-06-28
1,335 reads
With SQL Powershell, you can check all your database backups in minutes, whether you have ten SQL servers or 100.
2016-04-25
3,517 reads
Execute these stored procedures to backup all your database daily and your transaction logs several time daily. Save space by using the overwrite feature.
2015-12-17
4,933 reads
This script returns the date for the most recent log/full backups and checks if a DBCC CHECKDB has ran within a week.
2015-07-23 (first published: 2015-06-23)
1,268 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Arun Sirpal
Being in the cloud does have many benefits, from lower administration to fast scaling...
A few weeks ago, I began answering every single T-SQL Tuesday from the beginning....
Hi I have a table Meter and a lookup table LookupTbl I need to...
There are about thirty fields in a table SaleOrderLines, I created some indexes ,...
Comments posted to this topic are about the item Thanksgiving 2020
Ask SSC