петък, 14 ноември 2008 г.

Sql Error #5077, Severity 16

Sql Error Number:5077
Severity: 16

Description: Cannot change the state of non-data files or files in the primary filegroup.


Possibly related links:
RESTORE (Transact-SQL)
For online restore of a non-primary filegroup, the database can stay in use ... In addition, RESTORE can restore full-text files only, as well as with database data. ...
ALTER DATABASE (Transact-SQL)
Data files should not be put on compressed file systems ... The primary filegroup cannot be ... You cannot change the state of this option when the ...
Glossary
... a change in phonetic value compared to the unmarked state. dialog ... the data in a database or in a subset of the files or filegroups of a database. ...
Glossary of Terms
... secondary data files to hold data that does not fit on the primary data file. data flow ... A state in which all the data values stored in the database are ...
ALTER DATABASE
... change the database name, filegroup names, and the logical names of data files and log files. ... the requested database state or option change cannot ...
ALTER DATABASE
... change the database name, filegroup names, and the logical names of data files and log files. ... the requested database state or option change cannot ...
Breaking Changes to Database Engine Features in SQL Server 2005
... is created and maintained in the PRIMARY filegroup of each user database for ... space is required for the tempdb data and log files in SQL Server 2005. ...
RESTORE Arguments (Transact-SQL)
If the backup contains the primary filegroup and a partial restore is being performed. ... the database with KEEP_CDC will not create the Change Data Capture ...
RESTORE (Transact-SQL)
For online restore of a non-primary filegroup, the database can stay in use ... In addition, RESTORE can restore full-text files only as well as with database data. ...
Errors 4000 - 4999
... at the beginning of the log are pending replication or Change Data Capture. ... Point-in-time recovery is not possible unless the primary filegroup is part of ...


User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!


Няма коментари: