About 152,000 results
Open links in new tab
  1. 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 …

  2. 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 …

  3. 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 …

  4. 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 …

  5. sql server - What is the use of "Backup set will Expire:" option …

    Jun 20, 2014 · While backing up the database, I would like to use " Backup set will Expire: " option to delete/overwrite old database backups. I am not able to use this option. Any advice on how …

  6. sql server - Difference between Backup and Snapshot - Database ...

    Dec 7, 2023 · Difference between Backup and Snapshot A SQL Server Database Backup will allow you to restore the database to the time the (FULL) backup was created. If additional …

  7. 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 …

  8. sql server - Ola Hallengren backup systax when excluding a …

    Jun 28, 2018 · Explore related questions sql-server ola-hallengren-scripts See similar questions with these tags.

  9. sql server - Unable to Backup to Network Share Using Standard …

    Sep 2, 2022 · 1 We have recently installed our first instance of SQL 2019 and are having a weird issue with trying to backup to a network share using the standard methods found in SSMS but …

  10. Backup internals - What happens when a backup job is running

    Jun 18, 2015 · Backup internals - What happens when a backup job is running - in terms of locking and performance overhead in SQL Server? Ask Question Asked 10 years, 4 months …