Questions tagged [vss]

The tag has no usage guidance.

1
vote
1answer
697 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. ...
7
votes
3answers
766 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 ...
2
votes
1answer
1k 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, ...
2
votes
2answers
952 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 ...
3
votes
2answers
567 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 ...
2
votes
1answer
129 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 ...
1
vote
2answers
170 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 ...
1
vote
2answers
305 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 ...
0
votes
0answers
1k views

Is VSS Backup a better solution than the native backup?

Since i started to work as a DBA, i'm making normal backups ( with scripts, ad hoc and etc ). What would be the better solution for a backup? lets say I need to migrate a 2tb database to development ...
0
votes
1answer
429 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 ...