Restoring SQL server 2008 R2

I cannot carry out any backup because the restore has been going on for the past 2 weeks.

Is the byte count moving for the restore job? Do you see any alerts in the alerts tab?

It is hard to tell what the problem here is, double click on the running job and take a look at the job history maybe there is already something indicated.

But if the byte count is not moving why not abort the job? Surely the agent on the target SQL server has all the DBs open and woudn't let them go while the job still runs...

...couple of other things to check out:

1. The RAWS agent is running on the target server and publishing correctly to your media server, either via IP address of server name.

2. Did you use AOFO when running the backup? If so, it's not recommended. Run a backup without AOFO and then try the restore again.

3. To cancel the job, try stopping the RAWS agent on the remote server. If this is a test server, you can delete the databases shown, so try stopping the SQL services on this server (if possible) before doing so.

The restore job on the media server console showed that it failedso there is no job running at all.

Hi Craig,

I will try to stop the SQL services and see what can be achieved from there.

Thank you.