Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Really don't get this - any ideas?

Status
Not open for further replies.

katgirl

Programmer
Jul 6, 2006
114
US
Hi,

I am posting this problem again...

I restored some databases last week. All the databases are fully online, and query-able. I am trying to set up jobs to create backups to a network share.

Problem is, when I try to back up I get this error msg:

Executed as user: domain\domainuser. The backup of the file or filegroup "sysft_Articles" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. [SQLSTATE 42000] (Error 3007) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.

I have never seen this type of error before. Any ideas?

Thanks
 
Figured it out - yet another incredibly annoying way Microsoft does things!

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top