Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [snapshot]

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

0
votes
1answer
15 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
51 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
211 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-...
0
votes
1answer
19 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: ...
0
votes
1answer
236 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 ...
0
votes
1answer
331 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 ...
1
vote
1answer
37 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 ...
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
107 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, ...
0
votes
1answer
109 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 ...
1
vote
1answer
131 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 ...
0
votes
1answer
213 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
2answers
151 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
151 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
145 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 ...
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
33 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
22 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
359 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
304 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
199 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
55 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
623 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
101 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
770 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
891 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
52 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
228 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
768 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
860 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
5k 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
122 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
500 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
35 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
333 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
83 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
2k 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
107 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
751 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
741 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 ...
0
votes
1answer
26 views

Help with updating and archiving data

I'm building a MySQL database and a frontend. One function of the database application is to make an invoice. I'm looking for a way to archive all of the data that went onto the invoice so that if ...
1
vote
1answer
86 views

Turning on RCSI on on-prem CRM 2015

We have crm-2015 on-prem, inplace and running and causing lot of deadlocks when someone tries to update anything in batch and same time if multiple users are reading those activities. We are ...
1
vote
1answer
861 views

Database snapshot “The requested operation could not be completed due to a file system limitation”

Preface At the company I'm working for we use database snapshots in our ETL process to ensure the data is in a consistent state. The snapshot files are placed on a separate disk (in our case the X:). ...
2
votes
1answer
384 views

SQL Server 2012 - Dropping Snapshots takes hours [closed]

We recently did a SQL Server upgrade from 2005 to 2012. We have a nightly job that drops a snapshot of an active database. The snapshots gets created again later in the day. Before upgrading, in SQL ...
50
votes
6answers
17k views

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 ...
2
votes
0answers
108 views

Persistence of a PostgreSQL visibility map through RDS snapshot and restore

I have a pretty huge (1,2 TB) DB on a big RDS PostgreSQL 9.6.1 instance (db.m4.4xlarge). The DB is static (no on-line transactions) and we are testing performance of scripts (mainly analytical queries)...
3
votes
1answer
75 views

Questions Concerning Database Snapshots

One of our divisions is running SQL Server 2012 SP1 Enterprise edition for no particular reason (I know, I know... the decision was made before my time and they are resistant to change). What I'm ...