The snapshot tag has no wiki summary.
0
votes
0answers
14 views
Should I keep pg_xlog on the same disk as data if using disk snapshotting?
We're running on EBS volumes on EC2. We're interested in leveraging
EBS snapshotting for backups. However, does this mean we'd need to
ensure our pg_xlog is on the same EBS volume as our data?
(I ...
2
votes
1answer
59 views
Would using timestamps solve consistency issues with snapshot isolation?
I'm considering using Snapshot Isolation for some large queries being send from an Access 2007 frontend. These queries are occasionally causing ASYNC_NETWORK_IO waits, and some blocking as well. I'm ...
3
votes
1answer
55 views
Database stuck in restoring and snapshot unavailable
I tried to restore my database from a snapshot. This usually took around a minute to complete the last couple of times. When I did it today, it didn't complete for around 30 minutes and the spid was ...
3
votes
1answer
50 views
Sql server snapshot isolation overhead when read_committed_snapshot is enabled
When SQL Server's read committed snapshot is on (and thus some amount of row versioning is necessary), is there any additional overhead caused merely by enabling snapshot isolation?
Snapshot ...
0
votes
1answer
41 views
READ_COMMITTED_SNAPSHOT support in SQL Server 2005 Express
I wonder if SSE 2005 supports the READ_COMMITTED_SNAPSHOT database option. What I found is this article: Features Supported by the Editions of SQL Server 2005. It states that SSE 2005 supports ...
4
votes
1answer
118 views
How can I query for existing database snapshots in SQL server?
I'm trying to create a t-sql query that can determine whether or not a given database has any database snapshots that were created from it.
For example, if I were to create a snapshot like this:
...
0
votes
1answer
201 views
What is the proper way to backup MySQL database with rsnapshot?
I want to backup my website that contains both user uploaded images and data stored in MySQL database such that they are always consistent with each other in any particular point of time. While ...
4
votes
1answer
62 views
How can I determine the date of a snapshot in SQL Server 2008r2?
I am working on implementing an ETL process to load data into a warehouse.
Part of this process is pulling data from our production server (Server P) to a staging server where the actual load into ...
3
votes
1answer
75 views
How widespread is the adoption and usage of database snapshots?
After reading up on database snapshots, it seems that they are useful as a backup and quick restore method for small DDL and DML changes. Additionally they are useful for large scale dev/test ...
1
vote
1answer
99 views
Snapshot not picking up new articles in SQL Server 2012 transaction replication when added through script
I am trying to add new articles to an existing publication in SQL Server 2012.
I am adding the article to the publication with the syntax
--add the table into the correct publication
sp_addarticle ...
2
votes
3answers
1k views
Why is my database stuck in the Restoring state?
I have some unit tests that manipulates data in a database. In order to guarantee that the database state is always the same throughout all the tests, we're trying restore a database snapshot at the ...
1
vote
0answers
110 views
Transactional Replication Snapshots causing serious locking after 2012 upgrade
I am experiencing serious locking when adding new articles to an existing transactional replication publication, which is hanging the website. This is the first time I have attempted this since I ...
6
votes
3answers
599 views
SQL Server 2008 mirrored Database with manual failover, need reporting database
Our current setup is a principal database used in production with a manual failover mirrored database for HA.
I need to setup a reporting database as well. What would be the best approach? Shall I ...
7
votes
1answer
273 views
Does SQL Server Snapshot replication completely copy the data every time or does it issue deltas?
I am looking at snapshot replication between two servers. Here is what I have:
500GB database
~500MB nightly bcp loads
~50MB daily transactions
I was asking other DBAs in the company about which ...
3
votes
1answer
86 views
SQL Server Snapshot Replication and SRDF compatability
Is there anything that breaks down if you use snapshot replication and then use SRDF for disaster recovery (DR) on the snapshot publisher?
Specifically I am asking is: On the DR system, would the DR ...
