Guest User

Untitled

a guest
May 24th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. USE master
  2.  
  3.  
  4. GO
  5.  
  6. CREATE DATABASE Test ON PRIMARY
  7. (NAME='Test',
  8. FILENAME= 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\Test_data.mdf',
  9. SIZE=4096 KB,
  10. MAXSIZE=UNLIMITED,
  11. FILEGROWTH=10%),
  12.  
  13. (NAME='Test_sekundarni',
  14. FILENAME= 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\Test_data.ndf',
  15. SIZE=4096 KB,
  16. MAXSIZE=UNLIMITED,
  17. FILEGROWTH=10%)
  18.  
  19. LOG ON
  20. (NAME='Test_log',
  21. FILENAME= 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\Test_data.ldf',
  22. SIZE=2048 KB,
  23. MAXSIZE=UNLIMITED,
  24. FILEGROWTH=10%)
Add Comment
Please, Sign In to add comment