SHARE
TWEET

1-setupCoreSpace

a guest Nov 18th, 2013 121 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. USE [master]
  2. GO
  3.  
  4. ALTER DATABASE [RIDW] ADD FILEGROUP [VNF_32K]
  5. GO
  6.  
  7. ALTER DATABASE [RIDW] ADD FILEGROUP [VNF_IDX]
  8. GO
  9.  
  10. ALTER DATABASE [RIDW] ADD FILEGROUP [VSTR_32K]
  11. GO
  12.  
  13. ALTER DATABASE [RIDW] ADD FILEGROUP [VSTR_IDX]
  14. GO
  15.  
  16. USE [master]
  17. GO
  18.  
  19. ALTER DATABASE [RIDW] ADD FILE ( NAME = N'VNF_32K', FILENAME = N'C:\jazzdw\VNF_32K.ndf' , SIZE = 51200KB , FILEGROWTH = 51200KB ) TO FILEGROUP [VNF_32K]
  20. GO
  21.  
  22. ALTER DATABASE [RIDW] ADD FILE ( NAME = N'VNF_IDX', FILENAME = N'C:\jazzdw\VNF_IDX.ndf' , SIZE = 51200KB , FILEGROWTH = 51200KB ) TO FILEGROUP [VNF_IDX]
  23. GO
  24.  
  25. ALTER DATABASE [RIDW] ADD FILE ( NAME = N'VSTR_32K', FILENAME = N'C:\jazzdw\VSTR_32K.ndf' , SIZE = 51200KB , FILEGROWTH = 51200KB ) TO FILEGROUP [VSTR_IDX]
  26. GO
  27.  
  28. ALTER DATABASE [RIDW] ADD FILE ( NAME = N'VSTR_IDX', FILENAME = N'C:\jazzdw\VSTR_IDX.ndf' , SIZE = 51200KB , FILEGROWTH = 51200KB ) TO FILEGROUP [VSTR_IDX]
  29. GO
  30.  
  31. ALTER DATABASE [RIDW] ADD FILE ( NAME = N'VSTR_32K2', FILENAME = N'C:\jazzdw\VSTR_32K2.ndf' , SIZE = 51200KB , FILEGROWTH = 51200KB ) TO FILEGROUP [VSTR_32K]
  32. GO
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top