1
vote
1answer
18 views

SQL Server 2012 Backups Not Compressing

We recently upgraded from SQL Server 2008R2 to SQL Server 2012 Enterprise. After doing this I noticed that our DB backups were barely compressing at all. Our 22gb DB was compressing down to about 4gb ...
7
votes
1answer
1k views

Why can NT AUTHORITY\SYSTEM create SQL Server database backups?

I have a scheduled task (in Windows Task Scheduler) that connects to SQL Server using SMO (Windows Authentication) and creates a database backup. So far, this task was running under the Administrator ...
2
votes
3answers
84 views

How should my hosting provider handle SQL Server transaction logs?

I received a support ticket today from my hosting provider (they created it), saying that my SQL transaction log had filled up and that they had truncated it, shrunk it and reset it to Full recovery ...
0
votes
0answers
83 views

MSSQL: savesets in EMC Networker

When taking over an existing Networker backup system, I have found that a single MSSQL: saveset generates several savesets. I understand that these savesets relate to each of the different databases ...
1
vote
1answer
76 views

Colliding/overlapping full and differential backups in SQL Server

I am trying to set up a monthly full backup and a daily differential. The full backup is currently on the 1st, but I might change it to the first Saturday. I need to retain full backups for a few ...
1
vote
3answers
101 views

SQL Backup Is Taking All My Hard Drive Space

I have a job that I run every day to backup my SQL database. I just bought a band new server and was going to transfer the database backup over to the new serer and restore it. Our database isn't as ...
0
votes
2answers
59 views

Does it change anything when I disable obsolete parameters in SQL Backups? SKIP , stats, Nounload , norewind etc

I am pretty new in managing Computersystems but I always want to know everything to get out the maximum. When we last time deployed a new version of our application I was given a backup script to ...
0
votes
2answers
76 views

Possible to take a backup of SQL Server 2012 DB and restore on 2008?

I want to take a backup of SQL 2012 and restore on 2008, is that possible ? I have this options which I can't change on DB. Thank you
0
votes
0answers
28 views

How does Windows Server Backup authenticate on a SQL Sever?

My unerstanding is that when making a backup with Windows Server Backup it calls on the vss shadow copy service to create shadows of various components. One of the vss writers is SqlServerWriter, ...
0
votes
1answer
110 views

How can I backup an SQL Server database using Windows Backup?

Apparently Windows Backup has some support for backup of SQL Server databases: Ability to recover applications. Windows Server Backup uses VSS functionality that is built into applications like ...
0
votes
0answers
16 views

SQL Server rotating Azure backups

SQL Server 2012 SP1 CU2 allows backing up databases into the cloud: BACKUP DATABASE myDatabase TO URL = 'https://mystorageaccount.blob.core.windows.net/mycontainer/myDatabase.bak' WITH CREDENTIAL = ...
0
votes
1answer
2k views

RESTORE detected an error on page (0:0) in database <database> as read from the backup set

I'm attempting to restore a SQL Server 2012 .BAK file to my local server. I've successfully restored this .BAK file before. However now, when I try, I get the following error: RESTORE detected an ...
0
votes
2answers
91 views

azure websites backup strategy [closed]

I hope this is the right place to ask this question. I have a simple azure website with a linked sql azure DB. I want to be able to back up both the ftp files and the SQL DB. What is the best ...
1
vote
1answer
63 views

To backup sharepoint, do I just have to backup the SQL database?

Sharepoint is basically running SQL Server under the hood as I understand it. Is backing up sharepoint as simple as just backing up the underlying SQL Server databases? Or do I also need some files ...
0
votes
2answers
2k views

Permission issue with SQL Server backup via Mintenance Plan

I am using SQL Server 2012 and have created a Maintenance Plan to backup user databases nightly to a folder on the hard drive. However, when this plan is executed it fails with an "Access is denied" ...
1
vote
2answers
1k views

How can I restore a microsoft sql server database backup to postgres?

I need to take a Microsoft SQL Server database backup (dump) file and import/restore into a PostgreSQL database. Does anybody have some sort of transform script (maybe a perl/sed/awk script) that ...
0
votes
1answer
301 views

windows 7 - sql server 2012 - Maintenanace Cleanup Task

My Team Foundation Server creates backups. I want to clear backups that are older than 5 days. Create Maintenanace Cleanup Task in Maintenance Plans of Management of Sql Server 2012. Point there ...
0
votes
1answer
30 views

Backing PDF files and SQL server DB

I have my own Windows Server an Asp.Net application hosted live. The application allows users to upload CV PDF files and I have the DB also on that server. Which steps should I take to ensure that all ...
0
votes
1answer
33 views

Remove Backup Configuration in SQL Server

I did a backup to a particular database and restore it in another Server. Now I want to remove that backup. But I couldn't remove it. Whenever I remove it, I got the attached error. Could you please ...
0
votes
1answer
89 views

Does SQL Server Maintainance Cleanup consider exact times when deleting old backups?

Let's say I have a daily maintainance task that: Backups all databases and then removes backups that are older than 3 days. Now let's say the first backup at day 1, starting at 10:00, results in ...
1
vote
1answer
260 views

Restoring Microsoft SQL databases to a different disk partition on the same server

We have a SQL Server 2005 box running Windows Server 2003 R2 Std 64bit. We have two production databases residing on one partition (which is an iSCSI software target), that partition got apparently ...
0
votes
2answers
144 views

Differential backup of new sql database fails until full backup is made

I have setup a job that runs every night and makes a full backup of all databases on the server. During the day, another job makes differential backups every few hours. The problem comes when a new ...
1
vote
1answer
71 views

SQL Server Backup File Significantly Smaller After Table Recreation

We run automated weekly backups of our SQL Server. The database in question is configured for Simple Recovery. We backup using Full, not differential. Recently, we had to re-create one of our tables ...
4
votes
1answer
77 views

Restore database from backup file, where file name matches reg expression

I am doing the below : RESTORE DATABASE UAT FROM DISK = 'E:\Databases\backup\MY_LIVE_20120720_070001.bak' WITH REPLACE But I want to be able to use a file location that ignores the numbers in the ...
1
vote
2answers
175 views

Servers configuration to improve performance and offer redundancy for ASP.NET site with SQL Server

I'm administrating a fairly large website (currently about 300 thousand page views a day) which is expected to grow fast. Currently both IIS and SQL Server are running in a quad core server, with RAID ...
1
vote
3answers
588 views

Getting data from this MS SQL bak file

The following commands restore filelistonly from disk = 'C:\....bak' restore verifyonly from disk = 'C:\....bak' produce this error The media family on device 'C:\...bak' is incorrectly formed. ...
1
vote
1answer
134 views

MS SQL Server, selective backup tool

I'm looking for an enterprise tool / product - paid or free that is designed to handle selective backup / restore of massive MS SQL Server databases. A simple usage scenario would be - from our prod ...
6
votes
1answer
507 views

What is the most efficient way to backup a directory full of large database backup files?

We use NetBackup here at Stack Exchange, and I'm working on revamping our backup policy to be more efficient. Currently, we use SQL 2008 R2 and have the SQL run maintenance plans to backup the data ...
0
votes
1answer
221 views

Can a Sql Server standard edition backup be restored to web edition

If I have two instances of Sql Server 2008 R2. One is standard edition, one is web edition. If I take a backup of a database from the standard instance can I restore it to the web edition instance?
1
vote
2answers
82 views

SQL Server 2008 - Service account for backups

I am setting up a backup software to backup all the databases on my MS SQL Server 2008. I want to configure a service account with administrator rights on the database. The service account have ...
0
votes
1answer
501 views

SQL Server Agent job fails to backup to remote folder

I have created a SQL Server Agent job (in SQL 2008 R2) to back up some databases on a server. This task runs fine when the backup folder is set to a folder on that machine, but when I try to set it to ...
1
vote
2answers
914 views

NTFS on iSCSI - Mounting two Server 2008 servers to same LUN

I'm aware that you can't mount a single LUN to two read/write NTFS iscsi volumes without massive issues unless you are using clustered servers. However, I'm curious about mounting 1 iscsi lun ...
1
vote
1answer
196 views

Backing up SQL backups on a network share

Currently I have Maintenance Plans configured to backup SQL Server databases to local drives, then the files are picked up by Commvault nightly, and my SQL server maintenance plan deletes the backup ...
2
votes
1answer
144 views

Prevent Non Copy Only Backups on SQL Server

I have a pretty standard backup scheme implemented: Fulls on Friday, Differentials nightly, Transaction Logs throughout the day. These are all automated tasks. Occasionally we will need to take "one ...
1
vote
1answer
139 views

SQL Server backup strategy consequences

In simple terms, I need point-in-time restore between full backups - what are the consequences in the following plan - the database is in full recovery mode: 1:00 AM Transaction Log Backup (no ...
0
votes
1answer
162 views

MSSQL Reduce Backup/Transaction Log Size Retaining Point-In-Time Restore

Current major problem with backup sizes - I have been through many questions but am finding conflicting scenarios. I have multiple databases with the same problem but using one as an example, here are ...
1
vote
1answer
228 views

Creating a clone of a SQL Server database via backup/restore

So I'm trying to 'clone' a SQL Server database by making a backup of the template, then restoring it to the new name. However, there's either something I'm missing or something I don't understand ...
0
votes
2answers
67 views

Adding Redundancy to Win 2008 and SQL Server

We have an Amazon EC2 Windows Server 2008 with SQL Server running Email2Database and another SQL-based windows application. There is a lot of critical data on this box and we need to make sure that ...
1
vote
3answers
1k views

How can I delete SQL Server differential and log backups earlier than the earliest full backup still on disk?

When I delete a full backup, I would like to delete all the files that are rendered useless once that full backup has been deleted: specifically, the differential and log backups that occur before the ...
0
votes
1answer
124 views

Backup SQL Server database to local machine

I'm connected to the remote database using SQL Server Management Studio 2008. I'm a little bit limited for space on my server, so I just want to do a backup to an external drive connected to my ...
3
votes
4answers
724 views

Lower the I/O priority for backups

I have a job that nightly runs a backup of all attached databases however it can bog the server down if someone is connected during that time. I have TONS of CPU overhead to work with (I am barely ...
3
votes
1answer
241 views

Queries re SQL Backup, log files and Log Shipping

I was given a MS-SQL server backup .bak file to restore on my machine which was about 25mb in size , but required 10Gb of free disk space because the log file was that size, which indicates that they ...
3
votes
3answers
733 views

SQL Server transaction log BACKUPS are very large

In SQL Server 2008 R2 I have a database that has full backups nightly and transaction log backups every ten minutes. The database is in full recovery model. The problem is that the backup files for ...
1
vote
1answer
643 views

SQL Server backup jobs run twice, but appears to be scheduled once

I have a scheduled backup that should run once per day, but runs twice. I've scheduled the job to run at 6:30 AM, daily. If I view the log of that maintenance plan, I can see that it ran today at ...
1
vote
1answer
817 views

Restore SQL 2008 database fails with error on page xxx:xxx

This is the situation: Got a full backup (.bak file) of a SQL 2008 database, with partitions. The .bak file is 100gb. I need to restore this database on a different server, to a new database. ...
1
vote
3answers
183 views

Microsoft SQL Server Management Studio

I have set up a job within MSQL studio to backup all of my databases to a specific file. Then I take that file, compress it, and send it to a backup device. I am currently hoping to make this entire ...
1
vote
1answer
48 views

SQL Server database backups storage

This is rather basic question. We do backups of all the databases on the server and size around 20GB every week. All that is scheduled (shrinking,Backing up) We store them on Network drive. Now ...
1
vote
4answers
937 views

User not functioning after backup and restore of database to another server in SQL Server 2005

We have a database called 'foo' on the first sql server instance called 'SQL01' that is backed up nightly via a snapshot with Snap Manager for SQL Server and then flex cloned and restored to a second ...
1
vote
1answer
82 views

SQL Server 2008: Is it possible to store differential backups in a separate files?

We're moving some of our applications to a new hosting provider and we want to make it seamless for our users. Nonetheless, we have big databases and we've got to move about 48GB of data. Our ...
5
votes
4answers
1k views

Lock Windows Disk for Backup (EC2 Snapshots)

I'm looking for a way to flush all pending writes to disk in Windows, then buffer all future writes until a command gives the go-ahead. I'd like to flush SQL Server writes and Windows system writes, ...