Database maintenance task (full back up) fails on SQL Server
Hi My daily maintenance job fails due to the below error from last 20 days regularly Executing the query “BACKUP DATABASE [shipment] TO DISK = N’D:backupshipment.bak’ WITH NOFORMAT, NOINIT, NAME = N’shipment’, SKIP, REWIND, NOUNLOAD, STATS = 10 ” failed with the following error: “Write on “D:backupshipment.bak” failed: 112(error not found) BACKUP DATABASE is terminating [...]

Answer Question   |  July 10, 2009  5:38 PM
Backup to Disk, SQL Server 2005, SQL Server 2005 backup, SQL Server 2005 maintenance, SQL Server administration, SQL Server backup, SQL Server maintenance

SQL Server database backup (URGENT)
Hi I have a db backup requirement. As shown in the attached image current system is as follows: There are three source databases such as DB001, DB002 and DB003. Each DB having one table as dbo.EMP and same table schema. Emp table consists of EmpID (PK) and EmpName. One backup database i.e, DBbackup I need [...]

Answer Question   |  November 28, 2008  11:14 AM
Database Backup, SQL Server 2005 backup, SQL Server backup

SQL Server restore duration
what DMV show restore info. including the duration of a restore?

Answer Question   |  November 17, 2008  4:00 AM
Dynamic Management Views, SQL Server backup, SQL Server DMV, SQL Server Dynamic Management Views, SQL Server restore

Microsoft Sequel Server 2005 VSS backup
What’s seems to have happened is that the SQLVDI.dll files in the 2 directories: C:Program Files (x86)Microsoft SQL Server80COM C:Program FilesMicrosoft SQL Server80COM are out of sync. This seems to have happened as a result of a service pack for MSSQL which was applied in Dev. The Microsoft Sequel VSS writer is unable to initialize [...]

Answer Question   |  March 22, 2011  11:45 AM
Hyper-V, Red Gate SQL Backup, SQL Server 2005, SQL Server 2005 backup, SQL Server backup, SQL writer, SQLVDI.DLL, Volume Shadow Copy Service, VSS, Windows Hyper-V, Windows Server 2008

SQL database backup
Am having 2 databases running on SQL SERVER 2000, OS(windows server 2003), so the backup for these databases are to suppose to run on monday, wednesday and friday 12:00 and 16:30 in the afternoons.So since last week the backups have been failing to run till today, and by checking the event viewer, this is waht [...]

Answer Question   |  November 12, 2008  8:45 AM
SQL Server 2000, SQL Server 2000 backup, SQL Server 2000 scheduled backup, SQL Server backup, SQL Server errors, Windows Server 2003

Backing up SQL Server 2005
Where can I find information on backing up SQL Server 2005?

Answer Question   |  November 7, 2008  8:56 PM
SQL Server 2005, SQL Server backup

SQL Backup File
I have two computers running sql server, sqlserver01 and sqlserver01. On sqlserver01 I backup the database locally to C:SQLBackupbackupfile.bak (db size: 150GB) then I copy and paste the *.bak file to sqlserver02 via the network. It finishes copying but when I try to restore it on sqlserver02 it fails. I have used tools like Eseutil [...]

Answer Question   |  June 24, 2009  5:52 PM
SQL Server 2000, SQL Server backup

Error message during SQL Server backup
We have a backup command that runs from within a command job on SQL Server A, and extracts data from SQL Servers B, C, D at different times to create a file on a SAN Drive. This is a daily job and runs successfully. Over the last fortnight, we have got the following error once [...]

Answer Question   |  October 25, 2008  4:32 PM
SAN, SQL Server, SQL Server backup, SQL Server errors

How to backup a SQL Server on a different Domain.
We have just upgraded our admin server, which has an SQL database running on it. This server is also on a different domain from the backup server, which is running Backup Exec 12. Has anyone got any ideas on how we can connect to this server from the backup server that is on a different [...]

Answer Question   |  October 25, 2008  9:35 AM
Backup, Backup Exec 12, Backup servers, Backup software, SQL Server backup

SQL SERVER 2005 MAINTENANCE PLAN PROBLEM
HI, SQL2K5 Maintenance plan does not delete old backups even when ‘backups older than 1 days’ is selected.so my backups are piling up and have to remove them manulally everyday. any solution? Marshall

Answer Question   |  October 16, 2008  2:06 PM
SQL Server 2005, SQL Server backup, SQL Server maintenance, SQL Server performance

Questions about a SQL database with hourly transaction log backups
We have a SQL database with a full recovery model that backs up the database once a day, along with hourly backups for the transaction logs. However, we only have one transaction log backup file, and it is overwritten every time. Are transaction log backups cumulative, and if so, does that one file contain all [...]

Answer Question   |  September 23, 2008  4:50 PM
SQL, SQL Database, SQL Server backup, SQL transaction logs

Backing up a SQL Server 2005 database on SQL Server 2000 EE
I have created a large database in SQL Server 2005 Developers Edition, and I intend to put my backup on SQL Server 2000 Enterprise Edition. Is there an easy way to go about this procedure?

Answer Question   |  September 18, 2008  5:42 PM
Backup & restore, SQL Server 2000, SQL Server 2005, SQL Server backup

How to create new ramco test server?
Plz help me,when i restore my sql database with ramco backup then my database is restore but problem is that front-end not lounch in my system.

Answer Question   |  August 19, 2008  3:50 AM
SQL Server 2005, SQL Server backup

db backup
why does sql bu returns a time out

Answer Question   |  August 6, 2008  7:20 AM
SQL Server backup, SQL Server errors

The purpose of an “undo” file in SQL Server
I performed a full backup on a development database (Full Recovery Model) in SQL Server, made some changes, backed up the transaction logs, made some more changes and backed up the transaction logs again. Now, when I restore the database using WITH STANDBY, it puts the database into a read only mode. I’ve noticed that [...]

Answer Question   |  July 18, 2008  6:49 PM
Backup, SQL Server backup, SQL Server restore, Transaction logs, WITH STANDBY

MSSQL$BKUPEXEC Service won’t start.
Hi All! I have a problem with this MSSQL$BKUPEXEC service after a power failure on my SBS Server Premium Edition, this service and along with these below are also not starting as they’re meant to be; Backup Exec Device & Media Service Backup Exec Job Engine Backup Exec Server BlackBerry Dispatcher BlackBerry Policy Service BlackBerry [...]

Answer Question   |  July 11, 2008  12:47 AM
MSSQL$BKUPEXEC, SBS, SQL Server, SQL Server backup

Unable to Restore Backup in SQL Server 2005
I am unable to RESTORE Backup through code in SQL Server 2005 from VB.Net, even though that code is running fine in SQL Server 2000. The code is: “restore database [” + databasename + “] from disk =’” + Me.lblSource.Text + “‘ with move ‘” & dfile & “‘ to ‘” + Me.lbldatafile.Text + “‘,” [...]

Answer Question   |  September 20, 2008  7:35 PM
SQL Server 2000, SQL Server 2005, SQL Server backup, VB.NET

SQL Server DB Backup
Hello, I am a new member and would like assistance understanding why when I attempt to schedule a SQL Backup it doesn’t seem to stick after I close and reopen it. I am doing the following: Windows Server 2003 – Enterprise Edition/SQL Vs. 8 1. SQL Enterprise Manager 2. SQL Server Group 3. Open the [...]

Answer Question   |  June 24, 2008  7:04 PM
Backup, backup database, SQL Server, SQL Server backup

Restoring SQL Server 2000 database
I want to restore a database in SQL Server 2000, using a specific name. I tried restoring it using Enterprise Manager, but kept getting the error ‘You must select a backup set to restore’. Why is this and how do I resolve it?

Answer Question   |  June 5, 2008  10:09 AM
SQL Server 2000, SQL Server backup, SQL Server Enterprise Manager, SQL Server errors

schedule a restore plan
using sql 2005, management studio,, how to schedule a daily database and restore plan.

Answer Question   |  May 8, 2008  1:58 PM
SQL Server 2005, SQL Server backup, SQL Server Management Studio, SQL Server restore