sql server - Setting BUFFERCOUNT, BLOCKSIZE, and …
Feb 6, 2016 · How It Works: SQL Server Backup Buffer Exchange (a VDI Focus) SQL Backup tuning large databases SQL Server Memory for Backup Buffer A Case Study: Fast and …
sql server - Large transactional log won't shrink after transactional ...
Jul 10, 2017 · The reason I only had 1 transactional backup was because I had disabled the job from running to avoid things spiralling further out of control. New DB is up and running and …
sql server - Attempting to backup to remote NAS but access is …
Apr 5, 2019 · Now, the account I am signed into has FULL permission and access to that share, my connection is my domain\myaccount, and from the VM I can even put \\Dl-nas-01\LOCAL …
sql server - How can I make a database backup go faster?
Feb 21, 2016 · Multiple targets for the backup can be very useful, but only in certain situations. Your source database can be read faster than your current single file backup can write. Your …
sql server - T-SQL query for date of last full backup, size and ...
Sep 21, 2016 · I'm using the below T-SQL query to determine the date of the last full database backup and also return the size and location of the backup file. My problem is that it won't …
sql server - Get last full backup and transaction log backup for …
Jan 14, 2015 · How to write script or a query that will display the last full backup and the last log backup for each database on each of the production servers using the system table …
backup - Restore a database with a different name on the same …
Dec 4, 2019 · I need a copy of a live database called Carers on the same server for testing purposes. The test database name will be Carers_Test. I took a backup of Carers using …
sql server - .bak file not visible in any directory in SSMS - Database ...
Jan 14, 2016 · I was given a backup file to restore but it was not visible to me while browsing. However I was able to acess the in file system but in in restore wizard using SQL Server …
backup - media family on device is incorrectly formed. SQL Server ...
37 I am trying to restore a .BAK in SQL server but get the following error: Msg 3241, Level 16, State 7, Line 1 The media family on device 'c:\glyn\JA.bak' is incorrectly formed. SQL Server …
Restoring encrypted database on another server (using Backup …
Sep 15, 2016 · I have two SQL Server instances on same machine. I want to create an encrypted backup on one of the databases and then restore it on the second instance. I am doing the …