|
|
|
Creating the
Image Gallery Pro SQL Server Database |
-
The Image Gallery Pro database
is emailed as a script file called ImageGalleryPro.sql.
Detach the file somewhere on your local computer.
-
From
within SQL Server Enterprise Manager, create a new database
called ImageGalleryPro. Right-mouse click on databases, then
select New Database.
-
Enter a database name of
ImageGalleryPro or another appropriate name.
-
Click OK when finished and an
empty is created.
-
Now execute the
ImageGalleryPro.sql script to create the tables and queries in
the database. From the Tools menu of Enterprise Manager,
select SQL Server Query Analyzer.
-
From within Query Analyzer, open
the ImageGalleryPro.sql script file. Select the
ImageGalleryPro database from the DB: drop-down menu.
-
Execute the script by clicking
the green  Execute
Query button. If executed successfully, several messages
appear indicating 1 Rows Affected....
Note: Be sure to create a
maintenance plan that backs up your database on a periodic
basis. We highly recommend daily backups as this will help keep
the log file size under control.
|
|
|
