In last few tips TIP #64 & TIP #65 we get information how to take backup & How to ensure it can be restore? Now lets me share some more information related to backup. Problem:- Sometimes , we are interested to know when last backup is taken for particular database ? Solution: The first …
Problem:- A good maintenance plan always said to take backup but sometimes it is very difficult to take backup of database just because of space constraint.We take backup but we don’t have enough space available.Solutions: SQL server provided the best way and gave us solution of compressed backup. Now how to take compressed backup let …