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 …
I am facing difficulties in backing up a database in MS SQL Server
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 …
sql server - What are recommended values for block size, …
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 …
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 …
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 - 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 …
sql server - backup databases SQL Always On - Database …
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 …
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 …
Restore a database with a different name on the same server
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 - 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 …