Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [snapshot]

The processes of creating a point in time copy of data.

The processes of creating a point in time copy of data.

172 questions
65
votes
8 answers

Is it possible to quickly create/restore database snapshots with PostgreSQL?

First of all, I'm a developer, not a DBA or sysadmin; please be gentle :) I'm working on an application workflow where a single user action will trigger complex changes in the database - creating hundreds of records in some tables, updating hundreds…
Zilk
  • 1,141
  • 2
  • 9
  • 13
16
votes
1 answer

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: CREATE DATABASE [DatabaseA_Snapshot] ON…
Jesse Taber
  • 295
  • 1
  • 2
  • 8
15
votes
2 answers

SQL Server database snapshots for integration testing

I am trying to define a way of working with a test database (in SQL Server) for our integration testing. My idea was to do these steps at the launch of the integration test assembly: create a totally empty database run the "create database…
marc_s
  • 9,052
  • 6
  • 46
  • 52
15
votes
5 answers

Backing up & restoring 10-20 SQL Server databases to a ~synchronous state?

I need to backup up 10-20 SQL Server 2008 R2 databases with sizes between 10-50 GB, while they are online and used simultaneously by a single enterprise app. I also need to restore them to a state that is largely synchronized across all databases (I…
bogdan
  • 171
  • 8
13
votes
1 answer

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 replication type to use. I was told to use Snapshot…
grid
  • 316
  • 2
  • 7
12
votes
1 answer

Remote queries at SNAPSHOT isolation level

I'm experimenting with snapshot isolation level. Whenever I try to access a linked server, I get an error: Remote access is not supported for transaction isolation level "SNAPSHOT" I wasn't able to find anything meaningful in BOL or Google on this…
VladV
  • 223
  • 2
  • 5
9
votes
1 answer

EC2 - How to correctly back up PostgreSQL data?

Here is the setup: 1 small Amazon Linux (EBS-backed) EC2 instance with 3 additional volumes. This is both a web server and database server. One volume for code, one for the PostgreSQL (8.4) data directory, and one volume to store WAL files from…
user1467836
8
votes
2 answers

Are SQL Server Database writes slower with Snapshot Isolation?

I have a lot of deadlocks going on in my system. I would like to use Snapshot Isolation to fix them, but my DBA has reserves about it. One of his concerns is that Snapshot Isolation slows down writes. This is because it has to write to cache and…
Vaccano
  • 2,550
  • 5
  • 31
  • 56
8
votes
2 answers

Advantage of using a database snapshot for reporting purposes

What is the performance advantage of using a snapshot of a database for reporting purposes? The way I see it, it would probably downgrade performance since for every write in the original database, another write would have to be done for the…
ivanmp
  • 2,323
  • 3
  • 24
  • 36
7
votes
2 answers

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 isolation causes some overhead by making rows a little…
Eamon Nerbonne
  • 203
  • 1
  • 7
7
votes
1 answer

What is the proper way to back up MySQL database with rsnapshot?

I want to back up my website that contains both user-uploaded images and data stored in MySQL databases such that they are always consistent with each other at any particular point of time. While searching for solutions, I found this application,…
Question Overflow
  • 1,009
  • 6
  • 16
  • 21
7
votes
3 answers

What methods are available to create a snapshot of an oracle database for testing purposes?

I am new to databases and have just been assigned to work with Oracle. We want to create a snapshot of the database for testing purposes that will allow us to revert back once we're done. I'm a bit confused as to what my options are. I've looked…
Megan
  • 95
  • 1
  • 6
6
votes
3 answers

Using SQL Snapshot Replication to refresh TEST databases from PRODUCTION. Why not?

What are the drawbacks and downsides? We want to schedule automatic nightly refreshes of 20 databases, approximately 1GB each, from the PRODUCTION server to the TEST server. We're setting up SQL Server snapshot replication to publish snapshot…
Lawrence P. Kelley
  • 163
  • 1
  • 4
6
votes
1 answer

Should snapshot agent continue to run in transactional replication?

We have transactional replication running for a large number of publications on sql server 2008 R2 2 node active/active cluster. I have noticed that the snapshot agent job runs hourly and it looks like it does a refresh of the publications…
Johnny Barnes
  • 61
  • 1
  • 2
6
votes
2 answers

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 beginning of these tests. The restoration code…
andrerpena
  • 981
  • 3
  • 11
  • 13
1
2 3
…
11 12