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