The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [snapshot]

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

Filter by
Sorted by
Tagged with
2
votes
3answers
1k views

Where do Database Snapshots store the information what pages have been copied to the snapshot files?

Database snapshot files are sparse files. Only when a page is modified the sparse file is being written to. Reads of the snapshot must be able to know whether the sparse file contains a copied page or ...
0
votes
1answer
223 views

Can't bring up slave from ec2-consistent-snapshot due to uncommitted prepared transaction

I'm struggling with bringing up a slave instance using a snapshot created by ec2-consistent-snapshot, in my log it's describing the fact that an unprocessed transaction exists, but isn't that what ec2-...
3
votes
1answer
41 views

SQL Server secondary replica snapshot with Basic Availability Group

I have the following scenario: I created an HA group of two nodes in SQL Server 2016 Standard (which is limited to two nodes, one database per group and a non readable secondary replica). I tried to ...
-1
votes
1answer
30 views

snapshot too old : roll back segment number with name too small error doubt

recently, i have been facing snapshot too old error. So, i tried to understand the why this is happening. Link to the snapshot too old article Still, i have some doubts regarding the error. If i ...
0
votes
0answers
11 views

Indexing with transactional replication snapshot

Is there a way to set up a database table structure and indexes on a replication subscriber prior to running the snapshot agent in order to skip having to add the indexes AFTER the snapshot has been ...
0
votes
1answer
404 views

Best way to create a daily snapshotted read-only db in RDS?

We have a PostgreSQL db instance in RDS. In our application we need to run a daily export in the early hours of every day, the export and transformation may take some time and one issue we've found is ...
0
votes
1answer
260 views

SQL Replication for Schema changes

I want to configure the snapshot replication for all the articles. The problem iam facing is first time all the articles got sync on the subscriber. But later on let suppose if there is a schema ...
6
votes
1answer
1k views

DB snapshot goes into SUSPECT mode (SQL 2014 on WIN2K8R2)

I was hoping someone here might have encountered this sort of issue and if so what did you do to fix it? Here's some details: DB server: SQL 2014 Enterprise (12.0.4100.1) OS: Windows 2008R2 ...
1
vote
1answer
787 views

EXPDP snapshot too old live monitoring

The likely errors that raises "snapshot too old"s during datapump export are well documented all over the internet such as : undo_retention parameter being too short redo logs groups are too small or ...
1
vote
1answer
146 views

Transactional Replication initialize from Backup Issues

I implemented Transaction Replication (pull subscription with distributor at subscriber) with initialize from backup. It was working good and today when i checked replication monitor,it shows error on ...
1
vote
1answer
33 views

Does pg_export_snapshot work across replicas?

This is probably of little importance, but it's possible in PostgreSQL to retrieve the transaction snapshot with pg_export_snapshot and restore it with set transaction to start a second transaction ...
0
votes
1answer
120 views

Group Policy - replication snapshot

Has anyone seen a domain Group Policy stop a transactional replication snapshot from being configured and executed "A required privilege is not held by the client". To cut a long story short... I am ...
0
votes
0answers
11 views

SQL Server 2014 Replication Subscription Sync

I have SQL Server 2014 Replication set up. It is my understanding that when you add a new subscription that it will truncate the table and re-insert/re-initialize the tables you are subscribing to. ...
0
votes
2answers
157 views

EC2 and setting up MYSQL Replication

my database size is very big around 100gb and when I restore it takes 3 days to restore. I am using amazon ec2. My question is I want to setup a new slave to MYSQL master, can I take a snapshot of ...
0
votes
1answer
322 views

Is it possible to support multiple snapshots / store a snapshot / restore from a snapshot to a state with another snapshot?

So, I would like to have a snapshot structure like the following: A snapshot 1 is taken. Some code is run, then a snapshot 2 is taken. Then some more code is run, and the database is reverted to ...
0
votes
1answer
168 views

DB2 Transaction Logs - can they be COPY-PASTE on another Disaster Recovery Server?

We have Server1 with Online Backup1, Archive Logs 1,2,3 for example and Transaction Logs from 1 to 10. We are interested in next scenario: If Server1 fails completely and we want to move everything ...
0
votes
1answer
158 views

quick checkpoints for development mode

i'm a programmer, not a dba. i need a mechanism to quickly make a snapshot of a database (oracle 11g XE) before i run migration. migration changes data, grants, DDL (tables, triggers, lexers, views ...
0
votes
1answer
19 views

What kind of changes does snapshot file store?

Assume that I created a database called [DBS] and inside that database I created a table called [products]. Then I inserted 4 rows into [products]. Afterwards I took a snapshot of [DBS]. As a result,...
3
votes
1answer
63 views

SQL Server 2016 SP1 + strategy for long term version retention (snapshots, temporal tables, other?)

We have a data mart fed from an upstream data warehouse that we generate reports out of for external parties. I have a business requirement to preserve the state of the database for each month end to ...
0
votes
1answer
61 views

how to change the publication settings via T-SQL?

I set up a new server to host some database publications. On the same server I set the distributor db. All goes on well, then while running a snapshot of a publication on transactional replication: ...
1
vote
1answer
90 views

Snapshot on Always On Availability Group in suspect mode

Our configuration is 2 SQL Servers 2016, enterprise edition, 13.0.5026.0, running on Windows Server 2012 R2. Created availability group with one database in it. Database has 3 data files in it, all ...
1
vote
1answer
147 views

Querying mirrored database

I need to create a snapshot of one of our mirror databases. I have gone through a couple of links and it looks like querying can be achieved here by creating a snapshot at a mirror server. However, ...
11
votes
1answer
4k 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 ...
0
votes
3answers
2k views

Backup standby database using LVM snapshot

Objective: Backup standby database (synchronous streaming replication) using LVM snapshot. When running pg_start_backup: postgres=# SELECT pg_start_backup('label'); ERROR: recovery is in progress ...
2
votes
1answer
74 views

Snapshot Folder Location for Replication with Clustered Instance

I am assigned to create a transactional replication with a SQL Server clustered instance for reporting purposes. I'm planning to use the Distributor and the Subscriber on the same box. Regarding the ...
0
votes
0answers
24 views

Snapshot replication from SQL Server 2012 to SQL Server 2008R2

We are using snapshot replication as a standby to replicate prod data for a month from 2012 to 2008R2 after migration from 8R2 to 2012, just as a rollback process. Using snapshot replication for 10 ...
2
votes
2answers
613 views

Unable to fully drop a database snapshot

I have a job that drops and re-creates a snapshot, it's currently failing when trying to create the database as it says the database already exists. The database however does not have an entry in ...
1
vote
1answer
422 views

Log Shipping with Database Snapshot for Read Queries

Company may implement Log Shipping with Snapshot. This provides basic Disaster Recovery with Reporting area. Server A OLTP contains database which log ships to Server B (ReadOnly-Standby), Snapshot is ...
3
votes
1answer
235 views

SQL Snapshot Redirect

Company is implementing Database Mirroring Asynchronous with Snapshot. This provides some Disaster Recovery with Reporting area. Server A Principal contains database which mirrors to Server B, ...
2
votes
2answers
61 views

Making Production database as Publisher and Distributor for Snasphot Replication

In our environment we are using Log Shipping as DR. Our primary database is a clustered instance. My requirement is to set up a snapshot replication for reporting purposes. My plan is as follows: ...
1
vote
1answer
1k views

Snapshot folder Access

I have set up a Transaction Replication, with the distribution server as subscriber itself and implemented pull subscription, to avoid load on my publisher. When I created publisher at my source ...
0
votes
0answers
133 views

Transaction Replication Issue

I am trying to set up a Transaction Replication. I encountered error when i created a Publisher.While creating publisher i gave SQL Server agent accounts for Snapshot Agent and Log Reader Agent. When ...
2
votes
1answer
1k views

Snapshot Backups for SQL Server Databases

We are researching the direction of using Snapshot backups for SQL Server, rather than more traditional backup methods. We are using CommVault (and would be for snapshot too..) I am trying to ...
1
vote
1answer
897 views

Restore the data from Snapshot Backup when the data spans over multiple directories?

Problem : I have one master and various slave on EC2, all running with the innodb_file_per_table as OFF. We have done some testing work on one of the slave say server A.and it takes a huge amount of ...
2
votes
1answer
55 views

Transactional Replication breaks when schema is changed in Publisher

We have set up Transactional replication where in two Publishers feed into one Subscriber , now if try to change the schema of any one Publishers or both publishers, replication breaks. We have ...
5
votes
1answer
269 views

Database ID of a non-existent database - time-out waiting for buffer latch on page appearing in error log

Background: I've recently started at a new shop with lots of databases in various states. I arrived this morning (having just been added to the SQL DBA mailing group) to find an email about the ...
0
votes
1answer
926 views

Global Read Lock for Snapshot of MySQL Data

I have a database that is entirely comprised of MyISAM tables(yes, I did not create it). I need to create a slave and start replication so we could point read-only queries there. Here is my idea: ...
2
votes
1answer
1k views

Snapshot_isolation_state_desc NOT turning off [closed]

I am trying to resolve the following issue and need your help. We wanted to turn on is_read_committed_snapshot_on and Snapshot_isolation_state_desc ON on our db! When I ran following command to ...
4
votes
3answers
6k views

How to undo every change made to a database in a controlled environment?

I'm doing system testing of a product, and several tests are severely changing the data of a demo database. The data is quite complex to create queries which will undo the changes done by the tests; ...
0
votes
2answers
162 views

Unpredictable performance of queries against snapshot

I've got a basic reporting solution working where we have a collection of views that get exported to CSV files on a daily basis. For numerous reasons, we don't run the reports against the ...
2
votes
1answer
583 views

Snapshot isolation transaction failed in database 'Master'

We have a production database running in snapshot isolation level. The application have a functionality where the user can selected a few records and command it to be processed. A lot is done while ...
0
votes
1answer
38 views

Are there open source RDBMS that support non-backup snapshots? [closed]

I'm not looking for point-in-time backups but some kind of "time machine" read-only functionality. For example when running a SELECT query I would like to tell the database to run it on the data as ...
1
vote
2answers
373 views

BCP - Different Schema

I have a transactional Replication (Non-SQL Server Publishers - Oracle) implemented for one SQL Server Database. Let's say Publishers: A, B Subscriber: C Note: I can not modify the Oracle DBs. The ...
2
votes
0answers
97 views

Cassandra's nodetool snapshot renders node unresponsive

I have noticed that using nodetool snapshot on a Cassandra node causes heavy load (100% on two cores) for around 10-30 seconds. The snapshots are around 1GB in size. During that time connections to ...
2
votes
2answers
3k views

Replication Access denied in Replication

I have a database on-prem, and I have an Azure account. I need to establish transactional replication from the on-prem to Azure. First of all I created a publication and after that I made a ...
2
votes
3answers
3k 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
0answers
112 views

Snapshot Agent - Transactional Replication - Why a complete snapshot?

Often, I will add a single article to an existing transactional replication publication. I then start the snapshot agent to copy the new article and it's data over to the subscriber. Most of the time, ...
1
vote
2answers
830 views

Can Sql Server Backups be replaced by a netapp SnapManager?

In the process of getting some new magic and high speed SAN devices I was told by those crazy magic-SAN-things-administrating IT people that it will be obsolete to perform ANY Sql-Server Backups in ...
0
votes
1answer
755 views

Drop & re-add subscribers to transactional replication

I'm trying to get stored procedures to execute on the subscribers, as seems to be best practice. I already have transactional replication running happily. I add a new stored procedure, and set ...
3
votes
2answers
1k views

Fast backup & restore of MySQL database to revert recent changes

I have a decently big MySQL DB (InnoDB) with size about 400 MB. Thus dumping the whole DB with mysqldump and restoring it back takes forever (more than 15 minutes, which is unacceptable). For ...