建立标准数据库结构代码for sqlserver

stonys

1. -- 创建数据库
   
2. USE master;
   
3. 
   
4. go
   
5. 
   
6. IF DB_ID (N'U8CLOUD') IS NOT NULL
   
7. DROP DATABASE [U8CLOUD];
   
8. go
   
9. CREATE DATABASE [U8CLOUD]
   
10. 
    
11. go
    
12. 
    
13. ALTER DATABASE [U8CLOUD] ADD FILEGROUP [NNC_DATA01]
    
14. 
    
15. 
    
16. go
    
17. ALTER DATABASE [U8CLOUD] ADD FILEGROUP [NNC_DATA02]
    
18. go
    
19. ALTER DATABASE [U8CLOUD] ADD FILEGROUP [NNC_DATA03]
    
20. go
    
21. ALTER DATABASE [U8CLOUD] ADD FILEGROUP [NNC_INDEX01]
    
22. go
    
23. ALTER DATABASE [U8CLOUD] ADD FILEGROUP [NNC_INDEX02]
    
24. go
    
25. ALTER DATABASE [U8CLOUD] ADD FILEGROUP [NNC_INDEX03]
    
26. go
    
27. ALTER DATABASE [U8CLOUD] ADD FILE(NAME = N'nnc_data01', FILENAME = N'D:\U8Cdata\nnc_data01_Data.NDF' , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA01]
    
28. go
    
29. ALTER DATABASE [U8CLOUD] ADD FILE(NAME = N'nnc_data02', FILENAME = N'D:\U8Cdata\nnc_data02_Data.NDF' , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA02]
    
30. go
    
31. ALTER DATABASE [U8CLOUD] ADD FILE(NAME = N'nnc_data03', FILENAME = N'D:\U8Cdata\nnc_data03_Data.NDF' , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA03]
    
32. go
    
33. ALTER DATABASE [U8CLOUD] ADD FILE(NAME = N'nnc_index01', FILENAME = N'D:\U8Cdata\nnc_index01_Data.NDF' , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP [NNC_INDEX01]
    
34. go
    
35. ALTER DATABASE [U8CLOUD] ADD FILE(NAME = N'nnc_index02', FILENAME = N'D:\U8Cdata\nnc_index02_Data.NDF' , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP [NNC_INDEX02]
    
36. go
    
37. ALTER DATABASE [U8CLOUD] ADD FILE(NAME = N'nnc_index03', FILENAME = N'D:\U8Cdata\nnc_index03_Data.NDF' , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP [NNC_INDEX03]
    
38. go
    
39. -- 调整临时表空间
    
40. declare @name char(50)
    
41. declare @sql nvarchar(500)
    
42. select @name=rtrim(name) from tempdb.dbo.sysfiles where status & 0x40 != 0x40
    
43. set @sql='alter database tempdb modify file ( name='+@name+',size=500mb,filegrowth=10mb)'
    
44. exec master.dbo.sp_executesql @sql
    
45. 
    
46. 
    
47. --切换数据库
    
48. use U8CLOUD
    
49. go
    
50. 
    
51. --启用快照隔离
    
52. declare @exec_stmt nvarchar(4000) select @exec_stmt='ALTER DATABASE '+db_name()+' set read_committed_snapshot ON ' exec (@exec_stmt)
    
53. --禁用并行
    
54. EXEC sp_configure 'show advanced options' , 1
    
55. go
    
56. reconfigure with override
    
57. go
    
58. sp_configure 'max degree of parallelism',1
    
59. go
    
60. reconfigure with override
    
61. go

复制代码

天空0390

这个 还需要修改吗？直接执行就可以了