Create SQL placeholder files

[This post was moved from my previous blog]

A little tip for SharePoint operations & maintenance consultants out there. If you have access to an SQL server and have slightly limited diskspace for logfiles and datafiles. Then I would recommend to place a large empty files for about 2GB on it. So if the disk goes nearly full (which would of course happen at the most inconvenient times….) , you can just delete the file and have a little buffer before the disk is 100% for preparing disk extension. Pretty neat little trick.

So – just create a large empty file using fsutil:​

This entry was posted in sharepoint. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s