SQL Backup Wizard

Last Post 03 Aug 2009 12:13 PM by zelgaddiss. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
zelgaddiss
New Member
New Member

--
03 Aug 2009 11:21 AM
This is an odd one that is getting on my nerves. Running the SQL backup Wizard comes back with just this error, nothing else. Happens during step 5 of the backup wizard no matter if I choose to take the DB's offline or keep them online. I'm running SSIS and Server agent on both servers, they can see each other and connect to each others DBs. Both are running the exact same version of SQL build.

If anyone has any ideas of why it comes back with JUST that error, or where I can get a more detailed error to maybe figure out this darn thing.
zelgaddiss
New Member
New Member

--
03 Aug 2009 11:41 AM
Have not tried it with a maintenance plan but SQL Agent is running on both

May need to speak simply I'm a complete newbie to SQL tasked to make a report server from scratch so this is getting interesting.
zelgaddiss
New Member
New Member

--
03 Aug 2009 12:13 PM
Here is the only report I have:
Performing operation...

- Add log for package (Success)

- Add task for transferring database objects (Success)

- Create package (Success)

- Start SQL Server Agent Job (Success)

- Execute SQL Server Agent Job (Error)
Messages
* The SQL Agent Job was suspended. (Copy Database Wizard)

Tried connecting to the backup and main DB server on the same Server Management Studio and ran iot again but still no go,

The only thing I could think of would be that the main server is 64 bit and the report server is 32 could that be causing the issue?
You are not authorized to post a reply.

Acceptable Use Policy