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 backups work …

Apr 11, 2022 · When I try to backup a database, it is showing this message : to accomplish this action set property devices. (microsoft.sqlserver.smoextended) I cannot able to select the file location to …

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

Mar 8, 2024 · 0 I have SQL servers running on onprem and Azure VM hardware. The backups write to a file share located on a network VM. I am wanting to change the backup destination to Azure blob …

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 return any data at …

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 Reliable Backup …

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 cannot process …

Sep 23, 2024 · I have SQL Server 2022 with Always On Availability Group on two Servers. SRVSQL01 - Primary Replica SRVSQL02 - Secondary Replica On SRVSQL01, the Full backup is performed …

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 "backupset" and related …

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 example: …