carlos

SO: Windows 2000+SP4

I am trying to migrate SQL 7 Ent +SP3 to SQL 2000 Ent, but is
remains blocked many hours in screen

"Setup initalizing the for server the upgrade process ",

the archives bin I have them in C: and the archives DATA I have them
in unit E:

it modifies (because it changes to the date and hour of the file) the
BDs master.mdf mastlog.ldf, model.mdf and modellog.ldf, but soon it
begins to modify tempdb.mdf and hours and hours there are had left. I
have proven to erase bd tempdb.mdf but it creates new with 0Kb and a
noncontinuous one with the installation.

some idea? Thanks

C: --> 700Mb free
E: --> 4Gb free

-------------------------------------------------------------
sqpstp.log
-------------------------------------------------------------

......
09:27:05 SetFileSecuritySQLAndAdmin for e:\mssql7 returned: 0, 0
09:27:06 SetFileSecuritySQLAndAdmin for C:\MSSQL7 returned: 0, 0
09:27:07 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
09:27:07 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\SQLServerAgent returned: 0, 0
09:27:07 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\Replication returned: 0, 0
09:27:07 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\Providers returned: 0, 0
09:27:07 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\Setup returned: 0, 0
09:27:07 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\Tracking returned: 0, 0
09:27:07 SetRegSecuritySQLAndAdminX for SOFTWARE\Microsoft\Microsoft
SQL Server\80 returned: 0, 0
09:27:07 Begin Action: UpdateSystemPath
09:27:07 Path successfully updated.
09:27:07
%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\sy stem32\WBEM;C:\MSSQL7\BINN;C:\Program
Files\Microsoft SQL Server\80\Tools\BINN
09:27:07 End Action: UpdateSystemPath
09:27:08 Upgrading databases on instance 'MSSQLSERVER'
09:27:08 C:\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 6 -Service
MSSQLSERVER
09:27:08 Process Exit Code: (0)
09:27:08 C:\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 1 -Service
MSSQLSERVER -StartupOptions \-f \-m \-T4010

-------------------------------------------------------------------
cnfgsvr.out
-------------------------------------------------------------------

Starting Service ...

Connecting to Server ...

driver={sql server};server=.;UID=sa;PWD=;database=master

Remapping Server Databases ...

[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully detached
database 'model'.

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution
completed. If DBCC printed error messages, contact your system
administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully attached
database 'model'.

[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully detached
database 'msdb'.

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution
completed. If DBCC printed error messages, contact your system
administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully attached
database 'msdb'.

[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully detached
database 'pubs'.

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution
completed. If DBCC printed error messages, contact your system
administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully attached
database 'pubs'.

[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully detached
database 'Northwind'.

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution
completed. If DBCC printed error messages, contact your system
administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully attached
database 'Northwind'.

Disconnecting from Server ...

Stopping Service ...

Starting Service ...

Connecting to Server ...

driver={sql server};server=.;UID=sa;PWD=;database=master

Configuring Server ...

[Microsoft][ODBC SQL Server Driver][SQL Server]Granted login access to
'BUILTIN\Administrators'.

[Microsoft][ODBC SQL Server Driver][SQL
Server]'BUILTIN\Administrators' added to role 'sysadmin'.

[Microsoft][ODBC SQL Server Driver][SQL Server]Granted login access to
'CEBANCDEA\Administrador'.

[Microsoft][ODBC SQL Server Driver][SQL
Server]'CEBANCDEA\Administrador' added to role 'sysadmin'.

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution
completed. If DBCC printed error messages, contact your system
administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Configuration option
changed. Run the RECONFIGURE statement to install.

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution
completed. If DBCC printed error messages, contact your system
administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Configuration option
changed. Run the RECONFIGURE statement to install.

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution
completed. If DBCC printed error messages, contact your system
administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Configuration option
changed. Run the RECONFIGURE statement to install.

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution
completed. If DBCC printed error messages, contact your system
administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Configuration option
changed. Run the RECONFIGURE statement to install.

[Microsoft][ODBC SQL Server Driver][SQL Server]You have just
reconfigured SQL Server's sort order. Table indexes on columns of type
char or varchar will be rebuilt when SQL Server is restarted.

[Microsoft][ODBC SQL Server Driver][SQL Server]You have just
reconfigured SQL Server's Unicode collation. Table indexes on columns
of type nchar or nvarchar will be rebuilt when SQL Server is
restarted.

Reindexing Server ...

SQL Server has been successfully configured!