In SSMS, right-click the database and select Tasks > Back Up. Select the Files and filegroups option. Select the files and filegroups that you want to back up and press OK. How to Create a File or ...

All the failures, including ConditionalAttributesTest, were just using filegroup as a placeholder rule that doesn't use toolchain resolution. To reply to your comment: I think it does make sense that ...

When creating code first migrations, there is no possibility to change the database filegroup of an object (table, index,...). Having all data and indicies in the PRIMARY filegroup of an SQL Server ...

Setting up In-Memory OLTP Database and objects Open the T-SQL script file “ASPStateInMemory.sql” and update the ‘CREATE DATABASE’ statement to replace the ‘FILENAME’ attributes to specify a path that ...

At this stage, these CFPs are not needed for operational correctness for our database. To state differently, the full database backup of the database will NOT include these CFPs but they continue take ...

Lazy revocation, however, is complicated when multiple files are encrypted with the same key, as is the case when using filegroups. In this case, whenever a file gets updated, it gets encrypted with a ...