Blog Post

save disk when doing backup

,

As a DBA, most of us will also take care of test environment. However test servers usually cannot afford to be as powerful as the real production servers.

One of the issue I got in my test environment is I also need to do regular t-log backup for the testing databases, which are restored from the prodcution dbs, however, our disk space of the test server is limited. So insead of doing the normal backup, I have to issue the following command:

Backup log MyDB to disk = 'NUL:'

This way I do not sacrifice the valuabe space on the test server, while I still get the normal benefit of doing the t-log backup, i.e. keeping the db log within control.

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating