Very Computer

by **Tom** » Sun, 07 Apr 2002 05:49:46

Hi,

I'm trying to upgrade from SQL Server 6.5 to 2000 using
the Upgrade Wizard. Everything runs fine until I hit the
Creating Databases task. I get a popup window saying with
the title "Create Database Errors Detected". The error
says "Errors were reported while the databases were being
created. How do you want to proceed?" My options are View
Error File, Continue With Errors (tried this, didn't
work), and Stop the Upgrade. My createdb.sql file is below
(with shortened file path names). Any ideas what might
cause this, or how to fix it.

-- ********** Statement #3 FAILED **********

CREATE DATABASE [DefectUser] ON
(NAME = [master1Data], FILENAME
= 'c:\..\data\master1.mdf', SIZE = 210608 KB)
LOG ON
(NAME = [master1Log], FILENAME
= 'c:\..\data\master1.ldf', SIZE = 1409024 KB)

GO
/******
MESSAGE: Microsoft SQL-DMO (ODBC SQLState: 42000)
DESCRIPTION: [Microsoft][ODBC SQL Server Driver][SQL
Server]Cannot create file 'c:\..\data\master1.mdf' because
it already exists.
[Microsoft][ODBC SQL Server Driver][SQL Server]CREATE
DATABASE failed. Some file names listed could not be
created. Check previous errors.
sysmessages error: '5170', SCODE_SEVERITY: '1'
******/

-- ********** Statement #4 FAILED **********

sp_dbcmptlevel [DefectUser], 65

GO
/******
MESSAGE: Microsoft SQL-DMO (ODBC SQLState: 42000)
DESCRIPTION: [Microsoft][ODBC SQL Server Driver][SQL
Server]The database 'DefectUser' does not exist. Use
sp_helpdb to show available databases.
sysmessages error: '15010', SCODE_SEVERITY: '1'
******/

I verified before running the upgrade that the
master1.mdf file didn't already exist.

Thanks,
Tom

by **Shri Anandpura [M** » Wed, 10 Apr 2002 01:33:12

Looks like the MDF is already created at the same location. Can you verify
this?
Please look at the following links:
Upgrading to SQL2000
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/tc...
itevents/sql 2000/tnt1-04.asp

Troubleshooting Homepage
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/pr...
ol/sql/reski t/sql7res/SQL7_Res.asp

Thanks
Shri Anandpura

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.

--------------------
| Content-Class: urn:content-classes:message

| Subject: Upgrade from 6.5 to 2000 problem
| Date: Fri, 5 Apr 2002 12:49:46 -0800
| Lines: 52

| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcHc42ujcIZZ7NIPQQWiwS5vdNo1xg==
| Newsgroups: microsoft.public.sqlserver.server
| Path: cpmsftngxa08
| Xref: cpmsftngxa08 microsoft.public.sqlserver.server:203967
| NNTP-Posting-Host: TKMSFTNGXA03 10.201.232.162
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi,
|
| I'm trying to upgrade from SQL Server 6.5 to 2000 using
| the Upgrade Wizard. Everything runs fine until I hit the
| Creating Databases task. I get a popup window saying with
| the title "Create Database Errors Detected". The error
| says "Errors were reported while the databases were being
| created. How do you want to proceed?" My options are View
| Error File, Continue With Errors (tried this, didn't
| work), and Stop the Upgrade. My createdb.sql file is below
| (with shortened file path names). Any ideas what might
| cause this, or how to fix it.
|
| -- ********** Statement #3 FAILED **********
|
| CREATE DATABASE [DefectUser] ON
| (NAME = [master1Data], FILENAME
| = 'c:\..\data\master1.mdf', SIZE = 210608 KB)
| LOG ON
| (NAME = [master1Log], FILENAME
| = 'c:\..\data\master1.ldf', SIZE = 1409024 KB)
|
| GO
| /******
| MESSAGE: Microsoft SQL-DMO (ODBC SQLState: 42000)
| DESCRIPTION: [Microsoft][ODBC SQL Server Driver][SQL
| Server]Cannot create file 'c:\..\data\master1.mdf' because
| it already exists.
| [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE
| DATABASE failed. Some file names listed could not be
| created. Check previous errors.
| sysmessages error: '5170', SCODE_SEVERITY: '1'
| ******/
|
| -- ********** Statement #4 FAILED **********
|
| sp_dbcmptlevel [DefectUser], 65
|
| GO
| /******
| MESSAGE: Microsoft SQL-DMO (ODBC SQLState: 42000)
| DESCRIPTION: [Microsoft][ODBC SQL Server Driver][SQL
| Server]The database 'DefectUser' does not exist. Use
| sp_helpdb to show available databases.
| sysmessages error: '15010', SCODE_SEVERITY: '1'
| ******/
|
| I verified before running the upgrade that the
| master1.mdf file didn't already exist.
|
| Thanks,
| Tom
|

by **Tom** » Sat, 13 Apr 2002 03:56:41

I made sure that the MDF file doesn't exist before the
start of the upgrade. I went as far as
uninstalling/reinstalling SS2000 to make sure all links
were broken. I am now attempting to go from 6.5->7->2000
(as far as I know, this is the same as using the upgrade
wizard). We've had this problem with a few of our
machines, as well as a customer machine that we're working
with. Any suggestions?

Thanks for the help,
Tom

Quote:>-----Original Message-----
>Looks like the MDF is already created at the same

location. Can you verify

Quote:>this?
>Please look at the following links:
>Upgrading to SQL2000
>http://www.microsoft.com/technet/treeview/default.asp?

url=/technet/tcevents/

Quote:>itevents/sql 2000/tnt1-04.asp

>Troubleshooting Homepage
>http://www.microsoft.com/technet/treeview/default.asp?

url=/technet/prodtechn

>ol/sql/reski t/sql7res/SQL7_Res.asp

>Thanks
>Shri Anandpura

>This posting is provided "AS IS" with no warranties, and
confers no rights.
>You assume all risk for your use.

Quote:>| MIME-Version: 1.0
>| Content-Type: text/plain;
>| charset="iso-8859-1"
>| Content-Transfer-Encoding: 7bit
>| X-Newsreader: Microsoft CDO for Windows 2000
>| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>| Thread-Index: AcHc42ujcIZZ7NIPQQWiwS5vdNo1xg==
>| Newsgroups: microsoft.public.sqlserver.server
>| Path: cpmsftngxa08
>| Xref: cpmsftngxa08

microsoft.public.sqlserver.server:203967

- Show quoted text -

Quote:>| NNTP-Posting-Host: TKMSFTNGXA03 10.201.232.162
>| X-Tomcat-NG: microsoft.public.sqlserver.server
>|
>| Hi,
>|
>| I'm trying to upgrade from SQL Server 6.5 to 2000
using
>| the Upgrade Wizard. Everything runs fine until I hit
the
>| Creating Databases task. I get a popup window saying
with
>| the title "Create Database Errors Detected". The error
>| says "Errors were reported while the databases were
being
>| created. How do you want to proceed?" My options are
View
>| Error File, Continue With Errors (tried this, didn't
>| work), and Stop the Upgrade. My createdb.sql file is
below
>| (with shortened file path names). Any ideas what might
>| cause this, or how to fix it.
>|
>| -- ********** Statement #3 FAILED **********
>|
>| CREATE DATABASE [DefectUser] ON
>| (NAME = [master1Data], FILENAME
>| = 'c:\..\data\master1.mdf', SIZE = 210608 KB)
>| LOG ON
>| (NAME = [master1Log], FILENAME
>| = 'c:\..\data\master1.ldf', SIZE = 1409024 KB)
>|
>| GO
>| /******
>| MESSAGE: Microsoft SQL-DMO (ODBC SQLState: 42000)
>| DESCRIPTION: [Microsoft][ODBC SQL Server Driver][SQL
>| Server]Cannot create file 'c:\..\data\master1.mdf'
because
>| it already exists.
>| [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE
>| DATABASE failed. Some file names listed could not be
>| created. Check previous errors.
>| sysmessages error: '5170', SCODE_SEVERITY: '1'
>| ******/
>|
>| -- ********** Statement #4 FAILED **********
>|
>| sp_dbcmptlevel [DefectUser], 65
>|
>| GO
>| /******
>| MESSAGE: Microsoft SQL-DMO (ODBC SQLState: 42000)
>| DESCRIPTION: [Microsoft][ODBC SQL Server Driver][SQL
>| Server]The database 'DefectUser' does not exist. Use
>| sp_helpdb to show available databases.
>| sysmessages error: '15010', SCODE_SEVERITY: '1'
>| ******/
>|
>| I verified before running the upgrade that the
>| master1.mdf file didn't already exist.
>|
>| Thanks,
>| Tom
>|

>.