| Anne Meyer 2003-04-11, 7:23 pm |
| Your filename for the log has a space before ' C:\....
I think it will not like this. Delete the space and try
again.
>-----Original Message-----
>When I create a DB with the following T-SQL statement,
errors are generated
>and I coudn't find such messages details in MS SQL Books
Online. What's it
>actually?
>
>USE master
>GO
>CREATE DATABASE BookShopDB
>ON PRIMARY
>(
> NAME = Bookshop_dat,
> FILENAME = 'C:\Program Files\Microsoft SQL
> Server\MSSQL\Data\Bookshop_Dat
a.mdf',
> SIZE = 4,
> MAXSIZE = 10,
> FILEGROWTH = 1
> )
>LOG ON
>(
> NAME = Bookshop_log,
> FILENAME = ' C:\Program Files\Microsoft SQL
> Server\MSSQL\Data\Bookshop_Log
.ldf',
> SIZE = 2,
> MAXSIZE = 5,
> FILEGROWTH = 1
> )
>GO
>
>Server: Msg 5105, Level 16, State 2, Line 2
>Device activation error. The physical file name '
C:\Program Files\Microsoft
>SQL Server\MSSQL\Data\Bookshop_Log
.ldf' may be incorrect.
>Server: Msg 1802, Level 16, State 1, Line 2
>CREATE DATABASE failed. Some file names listed could not
be created. Check
>previous errors.
>
>
>.
>
|