All Questions

Tagged with
Filter by
Sorted by
Tagged with
12
votes
2answers
621 views

During a log backup is the data backed up to the start or end of the operation?

Say I am running a log backup, and that log backup takes 10 minutes to complete. During that 10 minute window, further transactions are run. Given the below example, which transactions does the log ...
0
votes
0answers
65 views

RESTORE VERIFYONLY FROM DISK is failing

We are having WSFC(Windows Server Failover Cluster) configuration for one of database server and from last few days, backup of one of the database is failing. Sometime backup itself fails whereas on ...
0
votes
1answer
74 views

Error 23 on transaction log backup, full backup works fine

I have a database with the database files on the E: drive, and logs files on the D: drive. I'm getting the following error when trying to run a transaction log backup: Read on "D:\LOG\AOA_Log.ldf" ...
5
votes
2answers
588 views

SQL Always On COPY ONLY backups - what's the point if I cant restore the AG from these backups?

Think I already know the answer to this but I'll ask anyway. Situation is: SQL 2012 Always On - 2 synchronous replicas. 7 TB worth of Sharepoint DBs in 1 AG. Before patching - I want a Full DB ...
1
vote
1answer
52 views

Incremental backup between now and backup taken one week ago

We do a full backup of our SQL Server 2012 database every night. A new developer needs an incremental (or differential) backup of a backup we took one week ago. The reason is that for them, ...
0
votes
1answer
56 views

SQL Full Backup job is taking too long to complete

I am facing a strange issue with daily FULL backup. We have a total of 23 databases. We have 1.21 TB big database in this SQL server 2012 Standard Edition. We are taking daily FULL database backup for ...
0
votes
1answer
19 views

Will this RedGate backup plan interfere with a new differential backup plan I want to create?

First, I need to get an assumption verified: If I setup a differential backup plan and someone comes along and manually creates a backup without specifying COPY_ONLY then it's going to throw the plan ...
2
votes
2answers
38 views

Will I be notified that BACKUP encountered a CHECKSUM error if I use CONTINUE_AFTER_ERROR?

I am in the process of adding the WITH CHECKSUM flag on our daily SQL backups, as part of an effort to better ensure data integrity. I definitely want to know if a checksum error is ever encountered, ...
0
votes
1answer
124 views

How safe is to use BACKUP LOG WITH TRUNCATE_ONLY

As per the title, how much is it safe to use BACKUP LOG db_name WITH TRUNCATE_ONLY in last STEP of any SQL-job execution? Randomly found on google that this Code line can be very harmful in use. But ...
2
votes
2answers
308 views

Restoring database with less data than the backup file

I'm not really experienced with DBA and SQL, so I need some recommendations from you. I have a production database backup file, however it is very large, so when I'm executing restore, for example, ...
0
votes
1answer
61 views

Server version error where restoring backup with SQL Server Management Studio

I have SSMS v17.9.1 freshly installed. I believe the only later versions as of this post's date and time are only preview versions. I am attempting to restore a .bak file. I get the error that: The ...
2
votes
4answers
821 views

.bak file not visible for restoration

There is a database on a server of which I would like a copy on my local machine for testing purposes, so I created a backup in the default disk location (C:\Program Files (x86)\Microsoft SQL Server\...
0
votes
0answers
47 views

Archiving SQL Server data on disk to be pottentially restored

Right now, we are backing up data per table into text/CSV files per month. This works fine for fairly small tables. For bigtables, the text files become so big that the restore process for a month ...
0
votes
1answer
200 views

The value for the parameter @MirrorDirectory is not supported error with Ola Hallengren Backup script

I am using Ola Hallengren's Maintenance Solution, and it's been working great for our environment. Quick question regarding the User Database backups s proc. Currently, when I'm taking backups, the ...
3
votes
3answers
113 views

Backing up a SQL 2008 DB, then restoring, gives a SQL 2005 (compatibility level 90) DB

We have four different databases on a SQL Server 2008 (not SP2 - don't ask me why) database server that have an odd problem. When listed from sys.databases, these databases report that their ...
2
votes
1answer
684 views

Killed Backup in Rollback State for Days

I killed a backup job of an 80 MB database which has been rolling back for days... I tried to take the database into single user mode, but that too hung in rollback state. I tried killing all ...
0
votes
1answer
48 views

How to accomplish such insert-or-update strategy?

Programming stored procedures isn't my strongest point when it comes to programming, but I'm trying to get better. I've stumbled upon a business requirement that's kind of hard for me and I was ...
0
votes
2answers
2k views

How to change the SQL Server Backup file (.bak) file default icon?

As I would like to say that by mistake the SQL Server 2012 backup file (.bak) open with wordpad. Due to this reason all backup files of SQL Server (.bak) file change with wordpad icon in entire the ...
-3
votes
1answer
59 views

SQL Server Backup does not run

After changing the sa password of SQL server 2012, the automatic backup doesn't run any more. Please see the log history: The backup was not implemented by me. Login failed for user 'sa'. ...
1
vote
1answer
1k views

Backup Plan on Always On using Maintenance Wizard doing Tlogs on Primary and Secondary

I have set my back up preference to primary and the secondary is not readable. Then I did the following: Set up the same maintenance plan on all replicas in the AG through the maintenance wizard. ...
0
votes
1answer
74 views

How do I use a different domain and username in a SQL Server BACKUP LOG command?

I looked here, https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?view=sql-server-2017#security I want to backup my log to a different server. When I do this through the SSMS,...
0
votes
1answer
161 views

LSN mentioned in Backup is missing in Backupset

I was testing some restore scenario for one of my requirement. SO while i was restoring i got the below error. --Msg 4305, Level 16, State 1, Line 79 --The log in this backup set begins at LSN ...
0
votes
1answer
124 views

Log Shipping Server Restart Problem

I have Log Shipping setup from Primary Server A to Destination B. Server B is both Destination and Monitoring server. Yesterday, we restarted both servers around the same time for patching. On the Log ...
1
vote
1answer
667 views

Should I have both Transaction Log Backups and Log Shipping

I set my database to Full Recovery a few months ago (to allow point-in-time restores) and set up Transaction Log backups with Maintenance Plan. Now we want to conduct Log Shipping with the same ...
0
votes
1answer
707 views

Log Shipping Monitor Server Instance

We plan to incorporate Log Shipping for basic disaster recovery with reporting needs. Server A Source Database will log ship to Server B database. We will conduct log shipping every few hours. ...
1
vote
1answer
829 views

Log Shipping Backup and Destination Folder Location [closed]

We plan to incorporate Log Shipping for basic disaster recovery with reporting needs. Server A Source Database will log ship to Server B database. We will conduct log shipping every four hours. ...
3
votes
3answers
1k views

Does restoring a full backup bring it to the backup START time or the backup FINISH time?

Backstory: I'm trying to restore copies of several SQL 2012 databases to a different environment, but the application needs them to be (roughly) "synchronized" in time. (Of course the ideal way to do ...
1
vote
1answer
111 views

Does a backup include dropped, hidden columns still in a table's physical structure?

If I have a table with an NVARCHAR(MAX) column and I drop it, the standard way to reclaim the space it used is to either: Rebuild the clustered index or Run DBCC CLEANTABLE If I didn't perform ...
1
vote
0answers
621 views

Ola Hallengren Backup - stuck at 100% complete

Full Backup started on 4/21 12 AM. While backing up one of the database, it is stuck. sp_WhoIsActive shows following information wait_info: (1208ms)PREEMPTIVE_OS_WAITFORSINGLEOBJEC CPU - 188,528,...
0
votes
2answers
68 views

How to take Backup of BackUp DB in SQL Server 2012

In Our environment, Log log shipping is configured and working good. Transaction logs are Backed-up on Primary Server. Copy to Backup DB Restore on Backup DB. Background: We are in process of ...
4
votes
2answers
4k views

Full Back up over to Network failed due to unknown network error 59

I am recently seeing the Unknown Netowrk Error 59 which saves the full back ups to a file share on some of the servers . The back ups happens at different times. Ola Halengren scripts are being used ...
0
votes
0answers
28 views

Analyzing the log backups to understand the pattern [duplicate]

I am not sure if my understanding is correct on this behavior of log backups. We believe the increase in traffic, as log backups have increased after migration event to cluster from stanadlone SQL ...
1
vote
1answer
206 views

SQL Server backups are suddenly smaller

On a Windows server 2012 R2 with MSSQL 2012 SP4 Express, installed with all the default options, I do daily backups of a small database with a scheduled task running the backup command with default ...
0
votes
1answer
2k views

Incremental Backups In SQL server

I am very much aware that native SQL server backups has full/differential/log backup strategies which are not really an incremental backups and would like to know if there are any 3rd party tools to ...
7
votes
3answers
3k views

(Ola Hallengren) Deleting log backups older than last FULL backup

When I deploy Ola Hallengren's backup script into my servers, I always set the @CleanupTime parameter for log backups to zero. This way, every time the log backup job runs, it checks for log backup ...
2
votes
2answers
9k views

Single user mode while restoring database

Is it necessary to put the database into single user mode before restoring a database? If so which one is more preferable putting the sql server into single user mode or putting the database only into ...
1
vote
1answer
34 views

Backup plan for development server

I have some SQL servers that are used only by developers, and the developers (i.e. me) are expected to maintain them. We really don't care much about losing data, so backups are not a priority, but ...
4
votes
2answers
2k views

Centralized Backup report for SQL server databases

Even though, I've searched couple of them online but still looking if there is a better way to manage the SQL server backups, almost across 250 servers. Issue is we are not allowed sysadmin login to ...
2
votes
1answer
783 views

Compression setting not effective for differential backup maintenance plan?

We are taking backups (Full, Differential, and Transaction Log) of databases using the maintenance plans feature in SQL Server. While taking the backup, I have chosen the compress option to compress ...
2
votes
1answer
420 views

Differential Backup from SQL Server 2012 to Azure Blob

I am attempting to backup a database to my Azure Blob storage. The databases are relatively large... between 1 and 30 Gig. I have successfully backed up the first day, but on subsequent days, I get ...
1
vote
2answers
73 views

Does the recovery model affect growth of the .mdf file? [closed]

On my production database, the .mdf file is rapidly growing on a daily basis. If I change the recovery model from SIMPLE to FULL, will that help?
2
votes
3answers
1k views

Maintenance plan don't stop & don't backup all databases [closed]

I have a server with 100 databases, I have a maintenance plan (MP) for backups. I noticed that the maintenance plan don't backup all databases when I'm looking at the backup folder destination I can ...
2
votes
1answer
581 views

Transaction Log backup overwrites full backup on same media

I have a database that is currently backed up every two hours using a SQL Agent job. This is a secondary backup, done in addition to the hosting provider's backup strategy. I created a procedure (...
0
votes
1answer
45 views

Why does backup file size become enormous when Agent schedule is changed?

I have a database that is currently backed up every two hours. This is a secondary backup, done in addition to the hosting provider's backup strategy. I created a procedure (stored within master) to ...
2
votes
1answer
718 views

Compressed Backup size value is incorrect in msdb

I am not sure if in am checking this correctly. But i can see the discrepancies in the value of compressed backup size from msdb.The value of compressed size is different what i see on the drives. ...
5
votes
2answers
896 views

Need suggestion on Back up Strategy [closed]

Our client has agreed to an RPO of one day data loss. So I am going to change back up strategy to eliminate space constraints. Database is in full recovery mode. Existing backup plan:- Once daily ...
2
votes
1answer
252 views

How to protect SQL Server 2012 Backups on Standard Editions

I understand that the password option to protect the SQL Server backups has been discontinued beginning with SQL Server 2012 and the feature to encrypt backups using certificates is available only ...
2
votes
1answer
687 views

Default instance name different than server name

I just started a new gig, and have discovered that two instances of SQL 2012 (SP2), installed on Core Server 2012 R2, have a different name than the server it's running on. They are both virtual ...
0
votes
1answer
272 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
253 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 ...