SQL problems with 2.0

Posted by Tad L on March 8, 2007, 7:37 pm

Please log in for more thread options

This is a weird database problem that has occured since upgrading to 2.0 -

We have been running 2.0 for a couple weeks now. Today I decided to look
more into my backup problem and try some other things. So I open
Administrator on my desktop, and try to "connect" to my database - It gives
me an error "To connect to this server you must use SQL Server Management
Studio or SQL Server Management Objects(SMO)." If I put in the wrong
password, it of course says "Login failed for user 'sa'".

Now if I go into "configuration" and click the "test database connection"
button, it connects fine. Manager works fine as well. This is true for all my
machines -

Now - we did install 2.0 on a test machine for a couple days before doing
the whole store - on that machine my partner installed some additional SQL
tools, and when I try the above tests there, I can "connect" to the database
from Administrator without a problem. But if I try to run the backup utility
from Administrator, I get this error message -

"Backup of file or filegroup "sysft_itemlookup" is not permitted because it
is not online. BACKUP can be performed using the FILEGROUP or FILE clauses to
restrict the selection to include only online data.
Backup of file or filegroup "sysft_subitems" is not permitted because it is
not online. BACKUP can be performed using the FILEGROUP or FILE clauses to
restrict the selection to include only online data.
BACKUP DATABASE is terminating abnormally."

This is the same message I get on my other machines when I try to run the
Backup from Manager -

The database is running on a SBS2003 server, all machines XP PRo, everything
up to date - All I want to do is backup my database simply and cleanly - Any
ideas?? Please????