Question : I am setting up a new merge publication, but I can not get the snapshot agent to run […]
Tag: snapshot
Excessive replication snapshot size causing failure
Question : I am searching for an explanation of a replication snapshot being in excess of 5 times what we’re […]
ADDM report dba_hist_snapshot
Question : How does ADDM report work? When I take two snapshots one for START: 05-OCT-2011 09:00:00, END : 05-OCT-2011 […]
Snapshot_isolation_state_desc NOT turning off [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Online index rebuild snapshot location and impact of filling index drive
Question : My understanding of a rebuild index online operation is that the index will have a snapshot taken and […]
Making Production database as Publisher and Distributor for Snasphot Replication
Question : In our environment we are using Log Shipping as DR. Our primary database is a clustered instance. My […]
What is the difference between database snapshot and VSS database snapshot backup?
Question : I have database backups configured via SAN disk tool. In the backupset table I can see the VSS […]
How to speed up restore database from snapshot in SQL Server?
Question : To revert a test database to an initial state (after running a test), I would like to restore […]
Why does creating database snapshot fail unless user is db_owner or sysadmin? MSDN suggests it should work
Question : MSDN suggests that CREATE DATABASE permissions are all that is necessary to create a snapshot. Any user who […]
.NET error when trying to create snapshot for transactional Replication
Question : I encountered a bizarre prob today while creating a transactional publication on a SQL 2012 server running on […]