sql server - Why can't I restore a backup? - Database …
Feb 3, 2025 · 2 I'm working with SQL-Server, using SQL-Server Management Studio (SSMS). In order to perform a restore of a backup, I have created an SQL Server login via SSMS, called …
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 - 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 - 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 …
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 - 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 …
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 - 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 …
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, 7 months …