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????