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 suddenly backups are slow and async_io_completion …
Jun 10, 2020 · HERE IS THE KICKER....Took a full backup of this 50gb and created a new db on the same SQL instance (alongside orig db). Executed a full backup on the newly created db …
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 - 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 - Restoring a SQL DB that had TDE turned on, cannot …
Feb 12, 2024 · I have SQLServer 2022 Developer on my machine. A customer has send me a SQLS 2019 backup file. When I attempt to restore it into a fresh DB, I get: Cannot find server …
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 - 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 …
sql server - Attempting to backup to remote NAS but access is …
Apr 5, 2019 · I was attempting to use Ola Hallengren's scripts to backup to a remote NAS, but it was failing and not giving any direct errors, so I tried doing it manually using Server …
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 - Cannot open backup device error - inaccessible folder …
Jan 13, 2023 · I cannot run backup jobs or commands when using folders OTHER than the ones specified in SQL Server Properties, here: Only those the backup can be saved to. For …