This procedure provides the information like when the backup/Restore for a particular database is started and what is the average time it will take to complete and from how long it is running and by when it will be completed. With this information we can wait for the average shown time for the completion of the task and we can take up other challenges instead of waiting on this for long time.
I Need a Backup and I Need It Now
Have you ever wished that creating a backup on the fly was easier and quicker? Whether you do it with the GUI or with T-SQL, you still have to open up Management Studio, connect to the database, and go through the steps. You have to figure out ...
2009-04-29
4,263 reads