0
votes
1answer
198 views

VB6 application backup using SQL 2005 suddenly failing

We have a windows server 2003 R2 machine running MSSQL 2005, and our XP workstations all run a VB6 application which calls the SQL backup utility to backup a 700 Mb database. A couple of weeks ago all ...
1
vote
1answer
258 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 ...
1
vote
1answer
116 views

Can I split open/divide a large MS SQL disk media set?

MSSQL 2005 An old maintenance plan was backing up a database to a single disk based media set with append. It contains numerous full backups of about 2GB each. I now have a single media set file ...
1
vote
4answers
211 views

Sql Server Backup Compatibility - 2008 with 2005

I'm hoping to restore a backup from SQL Server 2008 into a Sql Server 2005 instance. Is there a way to have Sql 2008 back up in a format that 2005 will understand?
3
votes
4answers
719 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
4answers
922 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 ...
2
votes
2answers
186 views

How To Backup A Maintenance Plan

I'm using SQL Server Management Studio 2005, and I'm about to make changes to the (rather important) Maintenance Plan. I would like to backup (or export) the Maintenance Plan, so it can be restored ...
0
votes
4answers
186 views

Shrinking Transaction log?

Why it is not recommended to shrink transaction log?
0
votes
3answers
688 views

SQL Transaction log backups after Full SQL Backups

Environment: VM with 20 gb of HD space and secondary hard drive with 3 gb. Windows Server 2003 and Sql 2005 Backup Scenario: Weekly Full backups with Backupexec Nightly Diff. backups with ...
2
votes
1answer
163 views

Sql server backups best practices. Too many files created?

I know this has been asked before, but I'm trying to understand this better. I traditionally used Backup exec to backup sql servers, but I now have two sql servers that are off-site and of course I ...
0
votes
1answer
68 views

Running two kinds of backup at the same time

I'm going to schedule a differential backup at 01AM and transaction log backup every one hour for a database. What will happen differential backup takes too long and transaction log backup starts ...
0
votes
3answers
60 views

How to do a single backup of SQL Server 2005 Data for out of place restore?

My problem: I got a virtual Windows XP machine with a specific database driven software installed using SQL Server 2005. A similar machine is also in use by several customers. One customer reports an ...
7
votes
4answers
713 views

SQL Server live database backup strategies

I'm trying to come up with a backup strategy for SQL Server 2005. I am thinking of doing full backup once a week, differential backup once a day and transaction log backup every 15 minutes. The ...
0
votes
1answer
98 views

How do i archive newly added DB backups?

I'm using Windows Server 2003, Sql-Server 2005 and 7-zip for archiving. Each day maintenance plan adds all DBs to backup and i need to archive those but just those files. How do i create .bat or ...
3
votes
2answers
1k views

SQL Server backup maintenance plan (full, trans log backups)

I've set up a maintenance plan to carry out: a nightly full backup (overwrites file) a 2 hourly transaction log backup (appends to 1 file separate to the full) The database is in Full recovery ...
1
vote
1answer
92 views

Restoring an 64 SQL server 2005 backup to a 32 bit installation

I am under the impression that this cannot be done, but would love to know if it can. And if so, why?
0
votes
3answers
3k views

How to move SQL Server 2005 Instance “root directory” without re-installing the instance?

Does anyone know a way to change the SQL Server 2005 default instance "Root directory" without re-installing the instance? I just installed a RAID5 SAN drive and I want the backups of the SQL ...
0
votes
1answer
38 views

SQL 2005: Backup database but ignore FTI Catalog

Folks, Apologies for aksing what might be a very simple question, but can I backup a database and ignore the databases FTI catalog? These backups will be restored to a different server and the ...
0
votes
2answers
682 views

SQL 2005 Log Shipping - Was working, now isnt!

I had log shipping working between two SQL 2005 server fine. I suspect that a job was added to the source server which backed up the transaction log to disk (nothing to do with the existing log ...
1
vote
2answers
2k views

SQL Server 'Real Time' Mirroring Possible?

We have a SQL Server that has important databases for our clients, if the server goes down we want another server to be ready to be switched over (we would just change the IP). The question is, how ...
0
votes
1answer
2k views

Can you make a SQL Server Maintenance Subplan run after a previous subplan completes

I have a maintenance plan to do backups and cleanup of old data. It has three subplans, each with their own schedule. Can I set the schedule of subtask 2 to be "after subtask 1 is complete"?
3
votes
2answers
352 views

Full/Differential backup - what's used to determine the differential backup content?

Let's say I have a 'MyDB' SQL Server 2005 database (simple recovery) in which I do a Full backup on Sunday, and Differentials every other night BACKUP DATABASE [MyDB] TO DISK = N'c:\Database ...
1
vote
3answers
1k views

SQL Server Backup problem when browsing to the directory

I want to allow a group (eg. 'BackupManagers') who can only preform backup and restore operations on certain databases. When creating the BackupManagers user account I checked db_backupoperator. When ...
7
votes
4answers
4k views

Best way to backup a SQL Server database nightly?

What is the best way to backup a SQL Server 2005 database nightly? I'm looking for a solution/strategy that would make the database backup file, and place it in an "outgoing" directory. We're ...
0
votes
2answers
269 views

SQL Server Partial Backups

We currently distribute snapshots of our database to our stores by using rdiff on compressed backups of the entire database. In order to optimize how long it takes to both create these backups, and ...
0
votes
1answer
194 views

How to remove database backups 2 days or older through SQL Server 2005 Integration Service?

I have a simple Integration Service package which has one SQL Task as shown below; WLSTAGE Bakup using Red Gate: Calls master..sqlbackup to backup database Here is the SQL to run the actual backup ...
1
vote
1answer
78 views

Is there a simple way to backup and restore all Microsoft SQL Server database objects related to a particular application?

I would like to backup, not only the databases that belong to a particular application living on a shared server, but also, those things that get stored outside of the database; the server accounts, ...
2
votes
2answers
185 views

benefits of periodic backup and restores on SQLServer

In the olden days when I used to use other database platforms, we were advised to back up and restore our databases periodically to improve performance. Common reasons were that a B & R would ...
0
votes
2answers
4k views

Unable to back up SQL Server databases using a maintenance plan

I am trying to create a maintenance plan that will run automatically and back up my SQL Server 2005 databases automatically. I create a new maintenance plan and add a "Back Up Database Task", select ...
2
votes
3answers
1k views

Restore MSSQL backup that was done with NO_LOG option

I am scripting the copy of databases from one server to another. Both are running SQL Server 2005 and the databases are in the Full recovery mode. The transaction logs on these databases can get ...
1
vote
1answer
279 views

Backup strategies in SQL Server 2005

thanks in advance for any help you can offer me on this topic. This is my first serverfault post coming over from stackoverflow. I have been setting up at work a SQL Server instance for an ...
0
votes
6answers
3k views

Is it possible to configure SQL Server 2005 to auto-compress backups?

I have created scheduled backup and shrink maintenance plans for my SQL 2005 instances using the tools in SQL Server Management Studio. I am wondering, is there an equally easy method for ...
0
votes
2answers
123 views

No History for SQL Backup

I have some SQL 2005 jobs which run nightly backups of the database to a local drive. The jobs are running OK (Well, I can see that they are doing something) because I can see a new backup file being ...
1
vote
5answers
642 views

Database backup - differential file size question

For my backup plan for SQL Server 2005, I want to do a full on Sunday: BACKUP DATABASE myDatabase TO DISK = 'D:\Database Backups\myDatabase_full.bak' WITH FORMAT GO Then I want to do a differential ...
1
vote
6answers
388 views

Copy database with Sql Server 2005

My situation is as follows: I have a production Sql Server 2005 database. Once a day I want to duplicate this database to another failover database which is on the same server instance. I don't want ...
3
votes
3answers
716 views

SQL Server do I need my differential backups?

I have about 10 databases on a server that I have in Full Recovery model and all are mirrored using Sql Server Mirroring. My current backup strategy is as follows: Full Backup 1am Differential ...
1
vote
4answers
1k views

SQL Server backup and restore process

Just wondering what backup processes you guys have. I am currently operating a weekly full database backup with daily differential backups. My understanding is that with such a set up, the ...
4
votes
3answers
546 views

SQL Server 2005: Proper Backup Schedule

I'm a .NET Developer and I know how to write SQL but am clueless at doing any form of database maintenance scheduling yadda So, I've recently taken over a project from a previous client. The site is ...
3
votes
2answers
418 views

How do you backup a database within SQL Server 2005 from the command line?

I need to create a scheduled task that will backup a database within a SQL Server 2005 instance. Is there a command line argument that I can use to achieve this?
1
vote
1answer
991 views

SQLVDI error - attempt to release mutex not owned by caller

I've started getting some errors in the App event log of one of our database servers (Windows 2003 & SQL Server 2005). The nightly full database backups are completing successfully however ...
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 ...
3
votes
1answer
2k views

SQL Server 2005 Restore from Backup Failing

I have .bak files for the database of a project my company recently took over. I was able to restore several of the .bak files, but the most important one is failing. When it fails I simply get a ...
0
votes
1answer
586 views

How do you backup CRM3.0 when the 'ftcat_documentindex' is offline?

My organisation uses Microsoft CRM 3.0, and I am attempting to backup the database. The following error is preventing me from doing so, does anyone know how to resolve this issue? Error: ...
2
votes
3answers
504 views

SQL 2005 Diff backups failing - no full backup exists?

I have a SQL 2005 SP 2 server running a maintenance plan that performs full backups every day at 22:00, diff backups every 4 hours and log backups every 30 minutes. The plan backs up all system & ...
2
votes
3answers
931 views

MS SQL 2005 — backing up to a shared directory

I have a SQL 2005 virtual machine running Windows 2003 on a 2008 server under hyper-v and I need to start backing up my databases to a shared folder. I have created similar backup jobs in other ...
0
votes
4answers
727 views

What is the best way to backup the schema of a sql server 2005 express database?

I want to backup the schema of a sql server 2005 database from the command line. Whats the best way to do this? Update I ended up buying SQL Compare 8.1 from Red Gate Software. It works just as ...
3
votes
3answers
1k views

Automatically Zip/Manage SQL Server 2005 backups

Is there a nice way to have SQL Server 2005 run nightly backups that are automatically zipped with only the last n backups kept? I know the agent can perform nightly backups, but I think the tricky ...
3
votes
6answers
1k views

SQL Server 2005 Backup Failing

I have a database in full recovery model. This database's transaction log backups (scheduled via a Maintenance Plan) fail nightly. Here is the database's CREATE statement, etc: USE [master] GO ...
0
votes
1answer
860 views

DPM server and mirrored SQL-server cluster

I want to use Data Protection Manager 2007 to backup two servers with SQL-server that have several mirrored databases. On ...
2
votes
2answers
211 views

Automated Backup Solution for a Virtual Private Server

My company has a VPS with a webhost that serves a few websites. I would like to set up an automated backup that will cover as much of the system as possible. Server Info: VPS is running in ...