/[AnywhereTS-MSSQL]/trunk/TSAdminTool/CreateDatabase.sql
ViewVC logotype

Contents of /trunk/TSAdminTool/CreateDatabase.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 120 - (show annotations) (download) (as text)
Sat Jul 14 09:39:59 2012 UTC (9 years, 3 months ago) by william
File MIME type: application/octet-stream
File size: 1002 byte(s)
+ don't specigy filename or log paths in CREATE DATABASE (let SQL Server handle that)

1 ÿþ-- This is the Anywhere TS main database creation script
2
3 --[Datadir] will be replaced runtime with the actual database directory, as chosen on the ATS config form.
4
5 USE [master]
6
7 GO
8
9 --CREATE DATABASE [AnywhereTS] ON PRIMARY
10
11 --( NAME = N'ats', FILENAME = N'[DataDir]\ats.mdf' , SIZE = 1536KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
12
13 -- LOG ON
14
15 --( NAME = N'ats_log', FILENAME = N'[DataDir]\ats_log.ldf' , SIZE = 768KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
16
17 CREATE DATABASE [AnywhereTS]
18
19

Properties

Name Value
svn:mime-type application/octet-stream

  ViewVC Help
Powered by ViewVC 1.1.22