CODEWITHSUNDEEP
sql-serverdatabase-backups
cdaaaaa
cdaaaaa

Reputation: 1

SQL Server - the backup is not permitted because it is not online

I'm new on this website and I hope I'm asking my first question in a proper way. I'm trying to backup a SQL Server database and I get the following error

System.Data.SqlClient.SqlError: The backup of the file or filegroup "sysft_ FullTextCatalog" 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. (Microsoft.SqlServer.Smo)

I googled it but couldn't find anything that helped. Does anyone has some ideas? Thanks.

Upvotes: 0

Views: 847

Answers (1)

Erik Pillon
Erik Pillon

Reputation: 471

The command

BACKUP DATABASE master FILEGROUP = 'PRIMARY' TO DISK='your/path/backup_file.bak'

should solve the issue.

Upvotes: 0

Related Questions