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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-07 : 00:17:12
|
tomas writes "an error was encountered when creating new database.
here is a part of errorlog
Thank you very much, good SQL guys...
Tom
2000-09-05 13:16:36.82 kernel Microsoft SQL Server 7.00 - 7.00.842 (Intel X86)
Mar 2 2000 06:49:37
Copyright (c) 1988-1998 Microsoft Corporation
Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 5)
2000-09-05 13:16:36.85 kernel Copyright (C) 1988-1997 Microsoft Corporation.
2000-09-05 13:16:36.85 kernel All rights reserved.
2000-09-05 13:16:36.85 kernel Logging SQL Server messages in file 'D:\MSSQL7\log\ERRORLOG'.
2000-09-05 13:16:36.95 kernel initconfig: Number of user connections limited to 32767.
2000-09-05 13:16:36.96 kernel SQL Server is starting at priority class 'normal'(1 CPU detected).
2000-09-05 13:16:37.12 kernel User Mode Scheduler configured for thread processing
2000-09-05 13:16:38.62 server Directory Size: 4023
2000-09-05 13:16:38.75 spid1 Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks
2000-09-05 13:16:38.75 kernel Attempting to initialize Distributed Transaction Coordinator.
2000-09-05 13:16:42.32 spid1 Starting up database 'master'.
2000-09-05 13:16:42.33 spid1 Opening file D:\MSSQL7\data\master.mdf.
2000-09-05 13:16:42.42 spid1 Opening file D:\MSSQL7\data\mastlog.ldf.
2000-09-05 13:16:43.05 spid1 Loading SQL Server's Unicode collation.
2000-09-05 13:16:43.12 spid1 Loading SQL Server's non-Unicode sort order and character set.
2000-09-05 13:16:44.44 spid1 16 transactions rolled forward in database 'master' (1).
2000-09-05 13:16:44.81 spid1 0 transactions rolled back in database 'master' (1).
2000-09-05 13:16:45.42 spid1 Starting up database 'model'.
2000-09-05 13:16:46.21 spid1 Opening file D:\MSSQL7\DATA\model.mdf.
2000-09-05 13:16:46.41 spid1 Opening file D:\MSSQL7\DATA\modellog.ldf.
2000-09-05 13:16:46.86 spid1 Clearing tempdb database.
2000-09-05 13:16:46.89 spid1 Creating file D:\MSSQL7\DATA\TEMPDB.MDF.
2000-09-05 13:16:47.00 spid1 Closing file D:\MSSQL7\DATA\TEMPDB.MDF.
2000-09-05 13:16:47.05 spid1 Encountered an unexpected error while checking the sector size for file 'D:\MSSQL7\DATA\TEMPDB.MDF'. Check the SQL Server error log for more information.
2000-09-05 13:16:47.09 spid1 Opening file D:\MSSQL7\DATA\TEMPDB.MDF.
2000-09-05 13:16:47.10 spid1 Opening file D:\MSSQL7\DATA\TEMPLOG.LDF.
2000-09-05 13:16:48.42 spid1 Closing file D:\MSSQL7\DATA\TEMPDB.MDF.
2000-09-05 13:16:48.50 spid1 Closing file D:\MSSQL7\DATA\TEMPLOG.LDF.
2000-09-05 13:16:48.62 spid1 CREATE DATABASE failed. Some file names listed could not be created. Check previous errors.
2000-09-05 13:16:48.62 spid1 WARNING: problem activating all tempdb files.
2000-09-05 13:16:48.65 spid1 Trying just primary files.
2000-09-05 13:16:48.65 spid1 Starting up database 'tempdb'.
2000-09-05 13:16:48.66 spid1 Opening file D:\MSSQL7\DATA\TEMPDB.MDF.
2000-09-05 13:16:48.85 spid1 Opening file D:\MSSQL7\DATA\TEMPLOG.LDF.
2000-09-05 13:16:49.11 spid1 Server name is 'BLABLABLASQL'.
2000-09-05 13:16:49.11 kernel Using 'SQLEVN70.DLL' version '7.00.842'.
2000-09-05 13:16:49.11 kernel Using 'OPENDS60.DLL' version '7.00.00.0839'.
2000-09-05 13:16:49.15 ods Using 'SSNMPN70.DLL' version '7.0.694' to listen on '\\.\pipe\sql\query'.
2000-09-05 13:16:49.15 ods Using 'SSMSSO70.DLL' version '7.0.694' to listen on '1433'.
2000-09-05 13:16:49.17 spid6 Starting up database 'msdb'.
2000-09-05 13:16:49.17 spid6 Opening file D:\MSSQL7\DATA\msdbdata.mdf.
...
...
...
2000-09-05 15:38:08.19 spid10 Creating file D:\MSSQL7\data\NewDatabase_Data.MDF.
2000-09-05 15:38:08.23 spid10 Closing file D:\MSSQL7\data\NewDatabase_Data.MDF.
2000-09-05 15:45:51.80 spid10 Creating file D:\MSSQL7\da |
|
|
|
|
|
create database error