Viewing 13 posts - 1 through 14 (of 14 total)
All,
Thanks for the suggestions. In the intervening time we didn't really get anywhere with this (amongst other head scratching from MS and Partners) so we opted to reattach the...
November 6, 2011 at 4:49 am
Interesting fact and partially related to your second suggestion, if I detach, copy and reattach the database to a different SQL server, I can back it up fine. So, I'm...
August 6, 2011 at 2:26 pm
Hi, really sorry about the long delay to your suggestions.
Have tried both of those. Enabling the Full-Text Index doesn't help resolve the issue.
I think what is most frustrating...
August 1, 2011 at 12:58 am
To verify, You are using native SQL backup, right?
Yes, all through the Management Studio.
Was a filegroup restore ever performed on this particular database?
No, we've never restored this database, it's...
June 29, 2011 at 2:53 am
Brandie Tarvin (6/23/2011)
Chris,Is this an upgraded database from SQL 2000?
No, this was a straight 2005 install originally. The backups have worked a long time in the past, but one...
June 23, 2011 at 6:53 am
Jason,
Yes, I've beaten the Full Text Catalogues to death, I think I've tried every possible permutation of advice as to what could be done with the FTC to resolve...
June 23, 2011 at 6:06 am
SQLRNNR (6/22/2011)
Since you only have 1 filegroup, have you tried a backup without using the filegroup options?
Yes, and with the same error (or close enough)
Msg 3007, Level...
June 22, 2011 at 9:32 am
Also I realise that we're on the SIMPLE recovery model, hence using READ_WRITE_FILEGROUPS, however we had exactly the same issue under a FULL model and I'm led to believe that...
June 22, 2011 at 9:02 am
GSquared (6/22/2011)
Before you do anything oddball with the files, can you post the actual backup command being issued?
In this particular instance, I'm running the backup through SQL Server Management Studio,...
June 22, 2011 at 9:00 am
No problem Brandie, I appreciate this is a tricky one!
The server is production (It's our Microsoft Dynamics CRM 4.0 Server) and being used continually, quite happily.
June 22, 2011 at 8:07 am
PRIMARY1FGROWS_FILEGROUP1NULLNULL0
June 20, 2011 at 9:06 am
CCT_MSCRM is in the Primary (and only) filegroup, which has only a single file.
I'm not sure how you mean with the different references to a database file and the...
June 20, 2011 at 7:26 am
They appear to be, if I query sys.master_files:
CCT_MSCRME:\DATA\CCT_MSCRM.mdf 0ONLINE
CCT_MSCRM_logF:\LOGS\CCT_MSCRM_log.LDF 0ONLINE
June 20, 2011 at 6:58 am
Viewing 13 posts - 1 through 14 (of 14 total)