problem with sql7 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

problem with sql7

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-04-12 : 08:59:34

massimiliano ferro writes "I don't create a new database.
The error is: "Error 1803, could not allocate enough disk space for a new database on the named disks"
I have space in disks e so ....

Thank you.."

izaltsman
A custom title

1139 Posts

Posted - 2002-04-12 : 09:47:21

So make sure you tell SQL Server to create the files on disk e: when you issue your CREATE DATABASE command... Something along these lines:


CREATE DATABASE mydb
ON 
( NAME = 'mydb_dat',
   FILENAME = 'e:\data\mydb_data.mdf' )
LOG ON
( NAME = 'mydb_log',
   FILENAME = 'e:\data\mydb_log.ldf' )

---------------
Strong SQL Developer wanted in the Boston area. Please e-mail if interested.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources