View Complete Post
According to John Ferringer, i'm moving this post from "SharePoint
Products > SharePoint Products and Technologies Forums
> SharePoint - Setup, Upgrade, Administration and Operation (pre-SharePoint 2010)
> Backup/restore Failed don't exist timer jobs".
Hi Folks, i'm recieving this message when i try to make a site collection/farm/site backup "The backup/restore job failed because there is already another job scheduled. Delete the timer job from the Timer Job Definitions page, and then restart
the backup/restore job.". I'm going to central administration/monitoring/timer jobs/check jobs status but i can not find anything.
- W2008 R2 EE
- MOSS 2010 EE
- MOPS 2010
- SQL Serve
When we failed to restore a backup from a BAK file for SQL Server 2008.
Then we find that the backup is created by using BACKUP xxxx COPY_ONLY parameter. When we attempt to restore from Management Studio (with the database changed to single user mode), we get the error message "There is NOTHING in the "Select
the backup sets to restore".
We would like to seek your advice on
1) Whether we can restore the database from Management Studio GUI ?
2) If not, can you suggest a SQL Script for the backup ?
Thanking you in anticipation.
In my C++ application (with MFC) developed in Visual Studio 2010 the user has an option to take a backup of the current database. This is done by executing a Stored Procedure which takes the database name and backup file name as parameters:
CREATE PROCEDURE sp2_backup_database @DATABASE nvarchar(100), @FILENAME nvarchar(260)
SET NOCOUNT ON
Exec ('Backup Database [' + @DATABASE + '] TO DISK = ''' + @FILENAME + '''
WITH COPY_ONLY, NOFORMAT, INIT, NAME = ''' + @DATABASE +
'-Full Database Backup'', SKIP, NOREWIND, NOUNLOAD, STATS = 10')
All this works fine, the backup is done properly by the SP.
What is bothering me is that when trying to make a restore of the database from the backup file the restore fails with a message like (freely translated from Swedish):
"Restore failed for [the SQL Server]. (Microsoft.SqlServer.SmoExtended)
System.Data.SqlClien.SqlError: RESTORE can not process the database [Database-name] since it's in use by this process. It's recommended to use master database during this task."
The only way I can
We have already configured log shipping on server. But now restore job failed with error message as "Skipped log backup file. Secondary DB"
Kindly provide resolution steps for same.