Database Reference
In-Depth Information
osql -Usa -PVMware1! -i sqlserverds2_create_all_20GB.sql
Figure 11.97
Building the databases.
The time it takes to create the databases will depend on the custom size you created. To
validate the script is building the databases, navigate to the database directory
(K:\MSSQL\database\) and log directory (L:\MSSQL\logs\) to validate the files have
been created and are growing in size as the script runs. In our environment, it took
approximately 40 minutes to build the 20GB database.
To validate the databases have been properly created, you can issue the following
commands, as shown in
Figure 11.98
:
osql -Usa -P<password>
use ds2
go
select count(*) from products
go