Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [vss]

19 questions
7
votes
3 answers

Is my restore process being badly affected by this third-party non copy-only backup?

This question may read like a duplicate, but is situation-based, and is posted from confusion applying the knowledge from other answers. I've read dozens of articles (among 1, 2, 3, 4), but am finding conflicting opinions (based on my understanding,…
EvilDr
  • 860
  • 4
  • 14
  • 29
3
votes
0 answers

Enable COPY_ONLY Backup Via DISKSHADOW Command Prompt

Introduction I'm experiencing weird behaviour on a virtualised (ESXi) Windows Server 2022 running SQL Server 2019 when the VMware conducts a snapshot of the server. It doesn't log the snapshot in the msdb database. On all our other SQL Server 2019…
John K. N.
  • 18,854
  • 14
  • 56
  • 117
3
votes
1 answer

What is the difference between database snapshot and VSS database snapshot backup?

I have database backups configured via SAN disk tool. In the backupset table I can see the VSS writer service is taking full backups of type snapshot. There are 85 databases on the server. I know about the concept of database snapshot and that…
variable
  • 3,590
  • 4
  • 37
  • 100
3
votes
1 answer

Use of third-party VSS backup plus native SQL backup

I have a SQL database server, and this uses R1Soft backup to take a server backup every 24 hours at 02:00. This is a full file system backup (bare metal plus daily differential, so includes the OS, etc.). I want to increase the backup frequency of…
EvilDr
  • 860
  • 4
  • 14
  • 29
3
votes
2 answers

Finding what's making VSS/VDI backups

This one's got me a bit perplexed. How might one determine what process/program is making file-level backups via VSS/VDI and the SQL Writer service? I've tried using Profiler to trace backup/restore events, and that just shows me SQL Writer itself…
db2
  • 9,708
  • 4
  • 37
  • 58
2
votes
1 answer

Freeze I/O on purpose like a vss snapshot

I want to freeze the I/O of a SQL Server instance like the shadow copy does. The result should look like this: 2020-01-19 23:11:40.90 spid73 I/O is frozen on database prod. No user action is required. However, if I/O is not resumed promptly,…
complete_stranger
  • 123
  • 6
2
votes
2 answers

Will VSS backups break logchain?

Our "hardware" dept has started some ASR replication on one of the servers where we run SQL Server. It seems that the method they use for this uses VSS, and I can see a lot of messages in the SQL Log about databases being backed up, and also the I/O…
GHauan
  • 615
  • 8
  • 24
2
votes
1 answer

Is it possible to use TSQL differential backups on a system that uses VSS?

Our colocation provider uses VSS to backup our dedicated server. The backups show up in the SQL logs as SQL backups even though they are not and that breaks the Full-Diff chain. The issue is well documented on StackExchange Database…
Alien Technology
  • 149
  • 4
1
vote
1 answer

VSSSQLwriter error

I've a SQl server 2019 on a Windows Server 2019 standard core, I manage two typer of backup, one with mantainance plans and one with Veeam Backup. The mantainance plans it's ok, the backup with Veeam fails every day with error on SQL leaving…
Stefano Ambrogi
  • 13
  • 4
1
vote
0 answers

How to solve Log shipping issues when Shadow copy volume-level backups are in place?

How to solve Log shipping issues when Shadow copy volume-level backups are in place? I tried setting up log shipping but it failed each time because the backup chain of the virtual log, the block number and the LSn log backups were different after…
Art V
  • 11
  • 1
1
vote
1 answer

What happens when SQL query is executing prior to snapshot backup and query executed during snapshot backup?

During vss based snapshot backup, databases IO is frozen one by one. And subsequently resumed. Questions: When there is a query running, and vss based snapshot backup is executed, will the freeze get delayed (that is - wait for running query to…
variable
  • 3,590
  • 4
  • 37
  • 100
1
vote
1 answer

Why do VSS Snapshots cause Availability Groups to fail over?

Why do VSS snapshots cause Availability Groups to fail over? Back in 2018, Ken Kellman and Erik Darling wrote that by freezing I/O on databases, VSS snapshots can cause Availability Groups to fail over. …
user763861
  • 43
  • 1
  • 6
1
vote
1 answer

I/O freeze on databases (SQL VSS)

Our company is considering a new backup product that is an all in one sort of thing (file system, AD, SQL, etc). The product relies on VSS snapshots to create the full backups for the SQL databases. This causes an I/O freeze on the databases that…
Joey Jones
  • 13
  • 1
  • 3
1
vote
2 answers

Transaction log uses (not backups of transaction logs)

Working with an interesting scenario that quite frankly, I have not had the time to test, and would love some expert insight. I have a question concerning transaction logs, and their possible use for recovery (or anything at all for that matter).…
user109140
  • 11
  • 2
1
vote
2 answers

Do I need to back up the log file drive when using VSS snapshots in simple mode?

We're currently using AppAssure to back up the SQL servers (2012/2014). It uses VSS snapshots. All databases are in simple recovery mode. Do I need to bother backing up the drive that contains the ldf files or is it enough to just back up the mdf…
agermano
  • 111
  • 3
1
2