|
Home > Archive > microsoft.public.cert.mcdba > April 2003 > DB creation error in SQL2000
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DB creation error in SQL2000
|
|
| Michael.NET 2003-04-07, 1:23 am |
| 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.
| |
| Michael.NET 2003-04-07, 1:23 am |
| Problem solved. There is a 'space' in log file path.
--
Michael.NET, MCSA
chiwing@hotmail.com
"Michael.NET" <chiwing@hotmail.com> wrote in message
news:et7NxZM$CHA.2148@TK2MSFTNGP10.phx.gbl...
> 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.
>
>
|
|
|
|
|