The copy-pastes and explanations blog for SQL code, errors and daily cases!
This blog is a 'list' of actions that always good to have available.
The copy-paste concept here is short and clear explanations and descriptions (no long stories!) and - of course - the code to take (copy) and use (paste).
The blog deals in the database (mostly) and software issues.
Blog Pages
▼
Add new FileGroup and new file to DB
ALTER DATABASE [<DB_NAME>] ADD FILEGROUP New_FileGroup
GO
ALTER DATABASE [<DB_NAME>] ADD FILE(NAME = N'New_FileGroup', FILENAME = N'E:\BackUp\DB_NAME_New_FileGroup.ndf' , SIZE = 50, FILEGROWTH = 5) TO FILEGROUP New_FileGroup
No comments:
Post a Comment