sql




Backup MSSQL database with compression

To create a full backup of MS SQL Server database with compression use this SQL command:

use YourDataBaseName
go

BACKUP DATABASE YourDataBaseName
TO DISK = 'Z:\BACKUP_FILE_NAME.bak'
WITH COMPRESSION

According to database size and your server capabilities, backup time can vary.

 

Get data and stats about files in document libraries in SharePoint site from SQL Server

SharePoint 2016 Logo

Information about files in document libraries is strored in the table "AllDocs" of Site's content database. Of course, Microsoft doesn't allow to make queries to SharePoint databases directly. But I can't but agree with inserts and updates are not allowed, but select query in the worst case will make just some locks in database. So I guess that in some cases it's much better to execute select query than powershell script.

(read more...)


MarkiMarta.com. Notes of web-specialist
Since 2009
18+