-1
votes
0answers
18 views

SQL Server 2014 backups failing for all databases [migrated]

Here is the error message in its entirety: Failed:(-1073548784) Executing the query "BACKUP DATABASE [MCM] TO DISK = N'F:\Backup\MCM\M..." failed with the following error: "BACKUP DATABASE is ...
7
votes
1answer
2k 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 ...
0
votes
1answer
140 views

SQL Server database backup to Windows Azure Recovery Service

I have some VMs on Windows Azure and IIS and SQL Server 2012 is installed on them. I also created a Backup Vault on Windows Azure and installed the Windows Azure Backup Agent on the VMs. It works ...
0
votes
2answers
60 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
0answers
100 views

SQL Azure automated export fails silently

I have a database in SQL Azure that's configured for a daily automated export but the export never occurs. I've tried turning off automated exports and re-enabling it, changing the time of day and the ...
0
votes
3answers
274 views

How does tape backup affect production systems such as SQL Server

I am not a systems person or a DBA, and as I was reviewing a bid for a project, I started to wonder how the tape backup (LTO-5 3000) affects live production applications such as Sql Server Databases ...
0
votes
1answer
34 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 ...
5
votes
1answer
421 views

MS SQL Server DB version without restoring?

Is there a way of telling which version of Microsoft SQL Server a database backup is from without restoring it?
0
votes
1answer
180 views

Can you a virtual service account access the network in workgroup

By default SQL Server Uses a virtual account for the sql server service: NT SERVICE \ MSSQLSERVER which is a Virtual Account. I know you can give this account nework access in a domain by adding ...
1
vote
1answer
217 views

Database backup with T-SQL script - Issue with Declare and Set Variables

Can someone tell me why I can't backup my database with the script below? I can run the script but it didn't create the backup. I"m using SQL Server 2008 DECLARE @pathName NVARCHAR(512) SET @pathName ...
0
votes
2answers
149 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
1k views

SQL Server 2012 Maintenance Plan succeeds but does not perform backup

I have a new SQL Server 2012 AlwaysOn Availability Group on Windows Server 2008 R2 Ent SP1. I'm creating a Maintenance Plan on the Primary Replica which is supposed to do Full (non-copy-only) backups ...
0
votes
1answer
529 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
1answer
206 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 ...
3
votes
1answer
127 views

SQL Server backups - transferring between instances

I work in a development shop where we primary use SQL Server for our day-to-day development and testing. Sometimes issues occur on someone's machine, often a labtop, that I would like to reproduce on ...
0
votes
1answer
257 views

MSSQL techniques to archive-backup content

We are now moving from a MySQL to a MSSQL 2008R2 database. As the project is a web application that we need to be able to scale well, we need to rework the way the DB handles data. We have 3 separate ...
0
votes
3answers
76 views

How to warehouse data that is not needed from MS SQL server

I have been asked to truncate a large table in MS SQL Server 2008. The data is not needed but might be needed once every two years. It will NEVER have to be changed, only viewed. The question is, ...
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 ...
1
vote
2answers
116 views

Is it possible to export a database without its Users?

Is it possible to export a SQL Server database (data, structures) without its users ? If yes, is it possible using SSMS ?
2
votes
1answer
463 views

Cleanup Backup Files without xp_cmdshell or maintenance plans

Background: We've got a backup script which needs xp_cmdshell to run. I decided that on new servers, we are not going to enable xp_cmdshell. I enabled xp_cmdshell when the job starts and turn it ...
0
votes
1answer
196 views

SQL Server 2005: Row in backup, missing in database

I've got a MS-SQL 2005 backup file. When I open with a text editor, despite being binary, I can see some information I want back. Nevertheless, when I restore the backup using MS-SQL studio, the row ...
0
votes
1answer
210 views

A utility to backup single tables on MSSQL?

Are there any Windows utilities that allow you back up single MSSQL tables? Having a lot or trouble finding any. I hear sqlbackupandftp is good, but as far as I can see, it doesn't back up single ...
2
votes
1answer
262 views

Full, Differential and Log backups of databases, MSSQL an MYSQL

Best I give a back story so you get the full picture. I am in the process of setting up a new business, which hopefully will start in April 2012, and as such I am preparing every aspect of it. One ...
0
votes
1answer
1k views

Error in backup query of SQL Server

I have a database in SQL Server and I want to create backup from it to a shared folder. just one of the network users has permissions to access to this folder. I have written a code to log on this ...
3
votes
3answers
797 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 ...
0
votes
1answer
75 views

Server restarted when I take database backup in SQL Server 2008?

I have 10 databases in my SQL Server 2008. If I take a database backup, 8 databases are working just fine. When I take database backup for the remaining two, at 50% of backup of process, the server ...
0
votes
3answers
2k views

Is it possible to make a backup of a MS SQL database from a linux command line?

Is it possible to create a local backup file of a remote Microsoft SQL Server database, from a linux command line? I know I can use SQLCMD from a Windows command line, but is the same possible from a ...
1
vote
2answers
138 views

Frequency of SQL Server full backups vs. diffs

I have a SQL Server located in a colo center. Currently, our database is about 100Gb. Log files average about 500Mb/day, and differential backups grow by a bit less than that. My current disaster ...
2
votes
1answer
298 views

SQL Server on EC2: What way do i set up the EBS

Good morning. We have a service with a SQL box on Amazon EC2 and, as suggested on this question, we are using EBS to store the data... the problem is, What is the best way to setup the storage? At ...
2
votes
1answer
202 views

Creating a small .bak file without indexes or excessive log

I recently was asked to ship a .bak file of our database to a client, and through reindexing all tables with a 100% fill factor (to make sure there were no empty slots), and resizing the transaction ...
0
votes
1answer
53 views

Does SQL Agent need to be running in order to take manual SQL backups?

If we have a situation where SQL Agent fails to start, will we still be able to take a full manual SQL backup? I don't mean scheduled backups and maintenance plans, just plain Right Click > Tasks > ...
0
votes
2answers
34 views

SQL Server backup

I have Full-Backup-A Transaction-Log-Backup-A Transaction-Log-Backup-B (*) - I have to restore this point Full-Backup-B How to do it? It seems that the only way is Full-Backup-A ...
1
vote
1answer
147 views

SQL Server 2005 SP3 Express Backups Incredibly Slow

I'm attempting to troubleshoot an issue with one of our customers who's using SQL Server 2005 SP3 Express to house their application data. The automatic backups that we perform when upgrading our ...
1
vote
2answers
343 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
3answers
197 views

basics of SQL Server 2008 backups

We don't have a DBA and I have to do backups. We have only one database that is 3gb (the others are less than 100mb). The 3gb database is write-heavy, and has very important data. I set up daily ...
0
votes
2answers
171 views

SQL Server 2008 import data from SQL Server 2005 backup file

I have a SQL Server 2005 database backup file (.bak), and I want to grab the data of this file and import it to an already existing database. Since the backup file contains database information as ...
1
vote
1answer
427 views

How to schedule backups in SQL Server 2008 Web Edition?

I have a SQL Server 2008 Web Edition and I used the Management > Management Plans > Wizrd to schedule the backup of all my databases. I executred the task to test it and I get this error: ...
7
votes
1answer
193 views

Does a failed full backup invalidate future transaction log backups?

I have a server running SQL Server 2005. I have nightly full backups, with transaction log backups every 15 minutes. This is a relatively small server so I am not doing any differential backups. If ...
2
votes
1answer
383 views

If I have full backup (.bak) and 3 differential backups (.dif) how can I restore them to a new database?

I need to check some old data. I need to check data from last night compared to data today. I am going to use SQL Data Compare to do this but I need to setup a fresh database to restore the backup to ...
3
votes
3answers
2k views

SQL Server Backup retention policy

I need to backup database in full recovery mode with a condition as: 1. Backup database, only when space is available for backup operation and Backup retention policy must be like expect last two days ...
0
votes
1answer
296 views

Maintenance Plan Reporting - Append To File - Clean Up?

Background: (SQL Server 2005, Standard Ed.) I have a maintenance plan running backups, taking a full backup 1/day, and t-log every 15 minutes. I have it set to create a text file report of each run, ...
1
vote
4answers
1k views

How do I restore a database on a remote SQL server 2005 from a local backup?

I have been given access to (parts of) a remote SQL Server 2005 with SQL Server authentication in order to be able to make changes to a database without involving other people who is not working on ...
0
votes
1answer
230 views

Recovery models, log shipping and log backup frequency in SQL05

Trying to get a sense of the optimal setup in our environment. I have a large SQL05 DB (500+GB) that is log shipped to a read-only system over a WAN. I'm currently running in FULL recovery model, ...
0
votes
4answers
131 views

Inexpensive Hardware for Database Backups?

What hardware would you recommend for saving database backups with the following setup: 5 separate physical hosts, each with one Sql Server 2008 database. Each instance is larger than 200Gb. Each ...
0
votes
2answers
90 views

taking database back up of SQL Server 2005

I have a requirement where I need to take the backup of database. Once the user clicks the button I need back up the entire database to the location c:/backup Database: SQL Server 2005. Thank ...
0
votes
2answers
4k views

SQL Server - remove a primary logfile without downtime

I have a MDF and LDF on the same drive, and the drive is almost out of space. I have a second drive in the same server, and I'd like to move the LDF file to that drive. I know that I can detach and ...