http://www.dotnetspider.com/sites/1332/-SQLDBPool.aspx
Category: Archive
Engineering notes from 2008–2014: SQL Server scripts, DBA quick-tips, and field notes from the trenches. Preserved as written — the foundation everything since was built on.
-
Trace Flag 3226
I have posted this article on DotNetSpider.com Please visit below link for more information.
http://www.dotnetspider.com/resources/37294-Trace-Flag.aspx
-
Key Points in Disaster Recovery
I have posted this article on DotNetSpider.com. Please follow link.
http://www.dotnetspider.com/resources/37324-Key-Points-Disaster-Recovery.aspx
-
Enabling Filestream to store compress documents
Problem: If you are in the process of enabling FILESTREAM on volume and you also want to ensure that documents will be stored in the compressed form but during that time you notice that volume F:\ drive is not formatted. You need to make sure that the volume will be able to store documents in a compressed form. You can fix the issue by using below command.
Command to format F:\
format F: /FS:NTFS /V:MYBLOBContainer/A:4096 /CThe above command will format the volume, convert it to NTFS and then label it as MYBLOBContainer. It will also set the NTFS cluster size to 4096. It is important to note that the cluster size must be 4096 or smaller for compression to be enabled for a volume. And at last, the /c parameter will compress the volume. When you are storing the FILESTREAM data, you can store it on a compressed or a non-compressed volume. The data in FILESTREAM is actually stored on the file system. There are a number of benefits to storing the data on the file system. For instance, you will be able to compress data with the NTFS compression capabilities. When the data is stored, it is in compressed form and when the data is retrieved, it is decompressed.
