Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [vss]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
476 views

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 ...
Stefano Ambrogi's user avatar
0 votes
1 answer
381 views

Using Ola Hallengren's succeeds to take full backups but fails to take a differential

I take weekly Full backups (all my databases are in Full recovery model) on Sundays and then schedule the Diffs to run nightly (except on Sundays). Looking through my logs I see this: Cannot perform ...
user263099's user avatar
2 votes
0 answers
342 views

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 ...
John K. N.'s user avatar
  • 17.9k
1 vote
0 answers
38 views

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 ...
Art V's user avatar
  • 11
0 votes
0 answers
379 views

SQL RESTORE FILELISTONLY query brings error in event viewer - BackupIoRequest::ReportIoError: read failure on backup device

I use the following query: RESTORE FILELISTONLY FROM disk = N'E:\Tmp\metadata2012.metadata' with CONTINUE_AFTER_ERROR --or even like that --RESTORE FILELISTONLY FROM disk = N'E:\Tmp\metadata2012....
isxaker's user avatar
  • 77
1 vote
1 answer
62 views

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 ...
variable's user avatar
  • 3,636
3 votes
1 answer
1k views

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 ...
variable's user avatar
  • 3,636
1 vote
1 answer
491 views

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 ...
user763861's user avatar
0 votes
0 answers
305 views

How can I mount vss snapshots and why we have to do that to take backup in window server backup?

"Windows Server Backup cannot guarantee Volume Shadow Copy (VSS) snapshots are retained. In certain situations, after restoring to a new volume, the VSS snapshots may no longer be recognized and ...
hg1735's user avatar
  • 11
2 votes
1 answer
959 views

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 ...
complete_stranger's user avatar
1 vote
1 answer
3k views

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. ...
Joey Jones's user avatar
7 votes
3 answers
857 views

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 ...
EvilDr's user avatar
  • 850
3 votes
1 answer
3k views

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, ...
EvilDr's user avatar
  • 850
2 votes
2 answers
3k views

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 ...
GHauan's user avatar
  • 603
3 votes
2 answers
1k views

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 ...
db2's user avatar
  • 9,658
2 votes
1 answer
371 views

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 ...
Alien Technology's user avatar
1 vote
2 answers
243 views

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 ...
user109140's user avatar
1 vote
2 answers
576 views

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 ...
agermano's user avatar
  • 111
0 votes
1 answer
798 views

what is running VSS on my server [duplicate]

Client's SQL Server farm DBs are backed up by third-party tool that does not use VSS. About half of the instances show backups being made by some tool that is using VSS. I can disable SQL Server VSS ...
Oliver's user avatar
  • 263