How to backup database using sql server 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

How to backup database using sql server 2005

Author

Topic

reddymade
Posting Yak Master

165 Posts

Posted - 2006-10-20 : 15:27:47

I am getting following error when i am trying to back up a database as a .bak file.

all i am doing is right clicking database and under task i am selecting backup daabase and when i click oK i am getting the error:

The backup of the file or filegroup "sysft_ccsIndexCatalog" is not permitted because it is not online

But i am able to backup database using sql server 2000.

2005 is giving problems.

Thank you very much for the information.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-10-20 : 15:43:05

BACKUP DATABAE YourDatabase
TO DISK = 'F:\Backup\SomeFile.BAK'
WITH INIT

Does that work?

Tara Kizer

reddymade
Posting Yak Master

165 Posts

Posted - 2006-10-20 : 16:15:05

I am gettingthe following error:
*****************************************************
Msg 3007, Level 16, State 1, Line 1
The backup of the file or filegroup "sysft_ccsIndexCatalog" 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.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

*******************************************************
the above database was created on sql server 2000 and recently we have upgraded to sql server 2005.

Thank you Tara.

quote:
Originally posted by tkizer

BACKUP DATABAE YourDatabase
TO DISK = 'F:\Backup\SomeFile.BAK'
WITH INIT

Does that work?

Tara Kizer

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-10-20 : 16:17:24

So have you looked into why sysft_ccsIndexCatalog is not online?

Tara Kizer

reddymade
Posting Yak Master

165 Posts

Posted - 2006-10-23 : 10:11:14

Hello Tara, can you please tell me how can i look for sysft_ccsIndexCatalog is online or not. I tried to find any info on google but found nothing with that keyword.

thank you very much.

quote:
Originally posted by tkizer

So have you looked into why sysft_ccsIndexCatalog is not online?

Tara Kizer

mr_mist
Grunnio

1870 Posts

Posted - 2006-10-23 : 10:17:21

I guess that this is some kind of full text index that hasn't been moved across to SQL 2005 with the rest of the database.

Or something.

-------
Moo. :)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources