All Questions

Tagged with
Filter by
Sorted by
Tagged with
0
votes
1answer
281 views

LSN numbers query regarding Differential backups

We have the following backup regime in place which I am not 100% sure about. Full backup each night at 18:00 taking approx. 6 hours Transaction log backup upon completion of full generally about 10 ...
-3
votes
3answers
254 views

How to administer large databases? [closed]

This is my situation right now: I'm working with SQL Server 2012, and I have 2 databases, one is 3.5 GB and the other one is 7.6 GB, and the company I work with is going to migrate the server to a new ...
2
votes
1answer
225 views

Is it possible to restore a SQL Server 2012 Standard backup to a SQL Server 2012 Web Edition instance?

If I take a backup from a SQL Server 2012 Standard edition instance can I restore it to a SQL Server 2012 Web edition instance?
1
vote
1answer
76 views

Improving Backup Performance using SQL native methodology

I am trying to gather some stats on comparison of run time vs performance between Litespeed backups and sql native backups. As we are no longer going to use Lite Speed [even though i personally loved ...
0
votes
1answer
829 views

SQL Server - Data Warehouse large log file, how to safely shrink?

My DW database is about 20GB size in data file and nearly 120GB in log file. Data staleness is until midnight (so "yesterday's news") and multiple databases are being replicated daily from ...
1
vote
1answer
87 views

Full backup of Simple recovery model - how much log is backed up if there is an open transaction

I have a situation right now. There is a database in SIMPLE recovery model. Note: 1. Compression is not enabled which will be enabled pretty soon. 2. SQL Server 2012 SP3 BackupSize: 8GB (Usually)&...
0
votes
1answer
18k views

The job failed. The Job was invoked by Schedule 1012

I am new on maintaining database backups, i have problem on my scheduled transaction logs, it was working before until i encountered the error below. Message: The job failed. The Job was invoked by ...
4
votes
1answer
2k views

Restoring database backup makes identity column start at 1 again

I created a backup of our database in SSMS 2012, using Tasks -> Backup as a Full Backup, including all data. When I restore this backup on another server (2012 as well), all identity columns are ...
4
votes
2answers
769 views

Setting DB to Simple Recovery then back to Full Recovery

I have recently inherited all of our company's SQL databases without much warning or experience, and was hoping to make a good impression and score a few quick wins by completely reviewing backups ...
1
vote
2answers
50 views

Strategy for backup for databases with little use (almost archived databases)

SYSTEM: I have a system with about 150 databases, each of about 2gb in size. 130 of those are mostly inactive but need to be online. Those are set to simple recovery, active dbs are set to full. I ...
1
vote
1answer
197 views

Recovery model from Full to simple and Shrink transact log result on poor performance

I'm new mantaining databases, I'm more like programmer but you know in some jobs you must be multitools because theres no specific dba. My boss told me to change the recovery model from Full to ...
2
votes
2answers
145 views

Use Netbackup 7.7 `WITH KEEP_CDC`

I'm using SQL Server Change Data Capture in a production database. To my surprise, I found that when restoring that database to a lower environment the CDC data is not kept—all the tables, functions, ...
1
vote
3answers
81 views

Backing up MS SQL Server database creates a huge transation log

I'm hosting a SQL Server 2012 database server with about 100 databases. I use the standard maintenance plan to backup all user databases daily and do hourly transaction log backups. One database, ...
2
votes
1answer
2k views

SQL Server: Transaction log still very large after log backup

I have a database that is on Full recovery mode. I previously made a full backup, and then on a daily basis add differential backups. Now I have backed up the transaction log for the first time, ...
0
votes
1answer
146 views

Text file report is not generating of Availability Databases other Databases during auto backup through maintenance plans in MS SQL Server 2012

I have setup Automated backup in SQL Server 2012 Enterprise Database backup through 'Maintenance Plan'. I have also configure AlwaysOn High Availability to that server .There is 5 databases in the ...
2
votes
1answer
1k views

SQLVDI and Backup Database event viewer errors [duplicate]

We recently started seeing SQLVDI and MSSQLSERVER errors poping up on a number of our machines. Shortly after event 3197 (I/O is frozen on database x), we start seeing SQLVDI 1 errors (signal abort) ...
1
vote
1answer
510 views

Log file increases while differential backup is in progress

Database server: Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 Database Size: 500+ GB We have a staging history database which stores what so ever operation(Insert, update, delete) is done on live ...
0
votes
2answers
121 views

Logs growing and took up entire log drive even with log backups [duplicate]

I have a volume just for logs and another volume just for log backups. The log volume kept growing until it to run out of space even with log backups taken every 1 minute. Isn't the backups ...
0
votes
1answer
416 views

Backup set expire option - Backup SQL Server 2012

I had seen an option while taking a backup i.e. set backup expire date, I have a doubt. What does this mean: Backup will be no longer valid after date DD/MM/YYYY? Backup declared with option, is it ...
8
votes
2answers
24k views

Restore a SQL Server 2012 backup file in SQL Server 2016/2014

I have SQL Server 2012 backup files and want to restore these to SQL Server 2016/2014. Will it work? I need to find this out before I uninstall SQL Server 2012.
1
vote
2answers
906 views

Unable to backup SQL Server from a newly added clustered drive

We have a clustered SQL server, and the backups of the databases are stored on the same drive where the data files are(F:). The storage team finally acted on my request to have a new clustered drive ...
2
votes
2answers
348 views

Concurrent backups (full and transaction) and testing recovery model

My intent is to test my recovery model and setup log shipping to replicate a database on another server. I have a database called AdventureWorks on a primary sql server. Presently SQL Backup performs ...
1
vote
0answers
398 views

SQL Server 2012 AvailabilityGroups - Preferred Backup Replica

I currently have a 2 node SQL Server 2012 HA Availability Group setup. Currently we have a number of SharePoint databases that exist in this availability group. I'm attempting to ensure our backups ...
2
votes
1answer
2k views

How to Load Balance Availability Group

I have 2 Servers under SQL Server Cluster (Server 1, Server 2) 2 Databases configured with Availability Group (Database 1, Database 2) Server 1: Database 1 PRIMARY REPLICA Database 2 PRIMARY ...
0
votes
0answers
46 views

Restoring a backup of 1 database to another puts both databases into Restoring mode

We have a 2 databases- Staging Test At times, we refresh out Test environment with a copy of Staging. We do this by taking a full backup of the Staging database and restoring it over the Test ...
9
votes
3answers
8k views

Why is .bak file size increasing/doubling with each consecutive backup on SQL Server?

I'm running a simple DB on SQL Server 2012 Express. Just today, when I backup the database, the .bak file size doubles to what it was from the previous backup just minutes before. I have done ...
0
votes
1answer
135 views

Database Log 3 times Data File [duplicate]

I have a set of database on full recovery model, my backup schedule looks like this: 1 Weekly Full Backup 1 Daily Log Backup Full backups are about 10GB, log backups are about 500mb per day. What ...
2
votes
1answer
415 views

What happens when two separate processes perform a full backup against the same database?

I have an instance of SQL Server 2012 RTM running. I have two separate applications that want to do a backup of a database lets call them "AppFull" and "AppFullCopyOnly". AppFull does a full ...
1
vote
2answers
4k views

Backup Error with Msg 3201, Level 16, State 1, Line 1 & Operating system error 3

When i am taking the backup in network share drive with mention below TSQL. Use DatabaseName Go Backup Database DatabaseName To Disk=N'H:\DatabaseBackup\DatabaseName.bak'; Go I am getting the ...
2
votes
2answers
1k views

Cannot see new drive in SSMS maintenance wizard

I'm trying to setup a Backup Maintenance Plan in SSMS for Sql Server 2012, running in a failover cluster on Windows Server 2012. The current plan backs up to the same cluster volume where the ...
1
vote
1answer
3k views

Automate backup using Windows Task Scheduler

I want to run an automatic backup of SQL Server 2012 Express using Windows Task Scheduler. I have 3 user databases. I want to backup all 3 user databases through a single stored procedure and a ...
-1
votes
1answer
383 views

Data warehouse backup strategy

I have a data warehouse development environment. Just as the production environment. it loads data every night from test OLTP databases. I want a backup every time the load process finishes. What ...
3
votes
1answer
129 views

Separate differential backup from one restored baseline

I work on a team that customises software, part of this customisation is stored as records in a database, part is customisations to the schema itself and there are often some specific records in the ...
10
votes
3answers
3k views

Backing up multiple databases to the same point in time

Usually when we start the backup we do not allow changes to commit or database will be not be accessible. I mean database will be in single user mode but I want to start the backup and release the db ...
4
votes
1answer
9k views

SQL Server BACKUP WITH FORMAT

When doing a SQL Server database backup using the T-SQL BACKUP statement, does WITH FORMAT only wipe out the specified Media Set or does it wipe out all Media Sets 'associated' with the database? ...
1
vote
0answers
309 views

Backup fails unless compression is enabled

I'm trying to back up a DB to a network share. The backup fails every time with the same error: BackupIoRequest::ReportIoError: write failure on backup device '\\share_name\Backups\filename.bak'. ...
1
vote
0answers
22 views

I only have the original files of database but no .bak file, how do I restore the database? [duplicate]

We were upgrading a server from SQL Server 2012 to 2014 at work and it was giving us trouble so I passed it off to someone else who, when backing up the SQL Server database, didn't create a .bak file. ...
6
votes
2answers
12k views

Set database offline with rollback immediate takes an hour to complete

Every night we take our production database offline, detach it, and then re-attach it to sever any active connections before start of our backup procedures. The first command is: USE master ALTER ...
6
votes
3answers
10k views

Unable to create restore plan due to break in LSN chain

My backup plan is: Full backup - once a day Differential backup - every four hours Transaction Log backup - every 30 minutes. All database backup are stored on my computer. I add some wrong ...
8
votes
2answers
2k views

Shrinking a SQL Server Transaction Log

I’m currently having to deal with a SQL Server transaction log that has got out of control. Disclaimer: I’m not a dba and this isn’t my area of expertise so please bear with me. Currently I have a ...
1
vote
0answers
237 views

Backup creating fork_point

I have a powershell script that is restoring from production into a test availability group database. It copies the full and t-log backups from production to test, takes the target db out of the ...
2
votes
1answer
745 views

Why SQL Server Express 2012 take automatically backup in “Virtual Device” without virtual device configuration?

I have noticed that after migration of SQL Server 2012 Enterprise to SQL Server 2012 Express, every day it shows "spurious" virtual backup after taking manual backup of database. When I execute this ...
-1
votes
2answers
96 views

Database BackupSize has Changed after migration from SQL Server 2012 Exterprise to SQL Server 2012 Express [closed]

I would like to say that after migration of MS SQL server 2012 Enterprise to MS SQL Server 2012 Express. I have seen there is some subtle diffence in DB backupsize as well as in "LSN" of all databases....
-3
votes
1answer
175 views

Backup file from SQL Server 2012 to 2008 [duplicate]

I have a backup file of SQL Server version 2012 but I want to restore that backup on SQL Server 2008. Question: Is this possible ?
10
votes
3answers
2k views

What is the use of restore headeronly when performing a backup?

When I monitor my backups with the following query: SELECT command, percent_complete, 'elapsed' = total_elapsed_time / 60000.0, 'remaining' = estimated_completion_time / ...
0
votes
0answers
26 views

How to align restore strategy with backup history cleanup? [duplicate]

I was curious about how that particular problem is tackled. 1) Full backups performed on saturdays. 2) Differentials every other day. 3) Tlog backups every 15 minutes. When trying to restore a ...
1
vote
1answer
55 views

How to determine how much storage to store backups?

I was thinking about this question ( Here where I work, we have a lot of space so backups are dayli ok ), and i'm thinking about if I was hired in another company, and see that they don't have backups,...
2
votes
1answer
492 views

Backing up / restoring a 20GB database with images stored as binary code

I am trying to backup and restore a 20GB database from a SQL Server 2012 to another SQL Server 2014, but I have come across the following issues: The developers [against best practice] have stored ...
1
vote
2answers
396 views

Partial backup restore of read-only file group on new database

Let's say, I have a database myModel2015 that contains two file groups - Primary A and Secondary Read-Only B. Then, I am creating a partial backup of the secondary file group. Now, let's create a new ...
3
votes
1answer
195 views

Why take full backups when you can do COPY_ONLY?

With a SQL Server 2012 availability group, you can only take COPY_ONLY full backups on replica. You can make regular BACKUP LOG. As it's possible to restore logs backups after a database restoration ...