0
votes
1answer
68 views

Delete files except ones created on sundays with in last 4 weeks

I have a script that copies some files around and deletes older files from destination. right now it just deletes everything older than 10 days. to increase backup retention we need to keep files that ...
0
votes
2answers
638 views

What is a typical Compression Ratio for an SQL Database backup file? [closed]

One of my clients want us to give a safe estimate of how much disk space does a compressed SQL backup file take. They need to size their server hard disks accordingly. We can rouhgly estimate the ...
1
vote
1answer
149 views

Failed Simple Maintenance Plan only when Full Backups do not run

Let me start off that I'm new to SQL administration and have inherited an older server that serves the main DB for our day in/out operations. So, my apologies in advanced to my beginner questions. ...
1
vote
1answer
239 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 ...
8
votes
2answers
889 views

Is it a good idea to back up SQL database to an External USB Hard Drive?

I will be installing a Database System on an Offshore Oil Platform (rack Servers). They have very limited hardware and space therefore sending up a backup infrastructure is not possible. Sending ...
0
votes
1answer
140 views

Do manual backups of SQL Server databases interfere with the automated backup process?

I was once told that running manual backups of SQL server databases from Managament Studio was a big no-no on production databases as it can interfere with the automated backup jobs on the server. ...
1
vote
1answer
69 views

Seeking Opinions - Is it a good idea to rely SQL backup 100% on transaction logs? [closed]

I'm in the midst of changing my company's SQL Server backup practice. We use to create full backups weekly and daily differential backups overnight. The issue is that as these full backups grow, it ...
1
vote
3answers
136 views

How frequent can we do SQL transaction log backups?

I'm installing a highly critical system. If the system fails, the users wants data up to the last minute. To achieve this, I was thinking of running Transaction Log Backups + FTP every minute. Has ...
1
vote
2answers
149 views

Is it a good idea to compress a MS SQL database backup?

Quick question! I heard that we should never shrink our databases. However, does the same rules apply to compressing our SQL backup? Thanks
0
votes
1answer
158 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 ...
0
votes
1answer
124 views

How to recover MYSQL databases from a hard drive backup

I have recently had a problem with one of my VPS's and I do not have a recent backup of the MYSQL databases, although I have a full backup of /var. I have determined from the MYSQL config that the ...
0
votes
2answers
140 views

Is it possible to restore table without backup in postgres

I have made some unfortunate UPDATE on a Postgresql table. Is it possible to reverse that change without any backup / rollback save etc?
3
votes
4answers
682 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 ...
1
vote
1answer
47 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 ...
-2
votes
0answers
22 views

DB Backup on Client when Hoster does not answer emails [closed]

I have got a strange situation where my website hoster does not answer support tickets any more. What I am trying to do is to do a full backup of my hosted sql db. I can access the db alright. ...
0
votes
1answer
72 views

SQL Server backup app

We are using DPM 2010 to backup our Hyper-V cluster however we require an client/agent and server SQL backup app for all of our Windows VMs, as to purchase an Enterprise DPM licence for each VM is to ...
1
vote
2answers
525 views

Constraint error - 'Could not enable or disable the constraint. See previous errors'

Yet I get no 'previous errors'. The line it gives me (by double clicking in SSMS) shows the second alter statement as the culprit: IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = ...
2
votes
4answers
717 views

Backing up a SQL Server 2008 R2 Database without stored procedures

Is it possible to back up a SQL Server database, but only back up the Table structures and content (i.e. not include the stored procedures, views etc?) The scenario: We have a data centre hosted ...
1
vote
3answers
842 views

Netapp snap mgr for sql vs. native backups

Moving to a new data center. The data center is going to use SRM replication for vm's, and netapp snap manager for sql for sql backups. We are currently using full/tlog native backups. How do the new ...
1
vote
1answer
378 views

SQL Server VSS Writer, Hyper-V and SQL Server 2008 backups

I have a virtual server running SQL Server 2008 R2. On the server I have configured two maintenance plans, one that takes differential backups every day except Saturday and a job that takes full ...
1
vote
2answers
341 views

how to choose backup strategy?

I am DBA of a big online retail company. I am responsible for the availability of the company’s database. The size of this database is 28GB, and it handles an average of 120 transactions every minute. ...
1
vote
2answers
233 views

Centralized Database Backup Server

We have database servers running on MySQL and Microsoft SQL. Is there a software that can do automated backups to all our database servers? I've already evaluated zrm of mysql(no web access,hard to ...
0
votes
1answer
308 views

Can Backup Exec 2010 Policy “steps” be bound to specific selection lists?

I'm trying to make a policy like this: Step 1: Backup everything in full Step 2: Come back and do transaction log backups on SQL/Sharepoint (with truncate) Step 3: Verify Backups. But when it ...
1
vote
1answer
728 views

SQL Server: How to make sqllogship.exe generate backup files with local instead of GMT files

When SQL Server log shipping generates transaction logs through a command like "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\sqllogship.exe" -Backup 60CD93F9-CFC2-4A84-8B06-3AD8DEADBEEF ...
2
votes
2answers
146 views

MS SQL differential backup strategies

We recently had a failure on one of our servers. The server was not accessible and we could get any data from it. We had a backup plan that took a full backup every second day and then then a diff ...
2
votes
6answers
516 views

SQL Server transaction log backups,

I have a question regarding the transaction log backups in sql server 2008. I am currently taking full backups once a week (Sunday) and transaction log backups daily. I put full backup in folder1 on ...
0
votes
1answer
952 views

automating sql express backup via VSS backup

I need to set up on my server automated daily SQL db backups (sql express, so no maintenance plans). To keep things simple I'm gonna use a backup solution (JungleDisk) that uses VSS to back up the DB ...
1
vote
1answer
386 views

backup sql databases, folders; 7ZIP and copy to ftp

We are quite stuck with which solution to choose for this backup issue: What should happen: First, there should be an interface were to choose several sql databases (sort of checkboxes or ...
1
vote
6answers
2k views

Microsoft SQL Server dump utility

I have a need to dump a fairly significant number of Microsoft SQL Server databases to .sql files. I have a Unix background, and am used to using tools like mysqldump and pg_dump for MySQL and ...
1
vote
5answers
305 views

Backup Solution for Moderate Usage SQL 2005 Server

Instead of sticking with our normal Backup Exec & LTO Tape system that we've used for production servers in the past, I'm looking at alternatives for our new SQL 2005 server that will go live in ...
19
votes
8answers
53k views

SQL Server 2008 Express - “Best” backup solution?

What backup solutions would you recommend when using SQL Server 2008 Express? I'm pretty new to SQL Server, but as I'm coming from an MySQL background I thought of setting up replication on another ...