on 05-29-2008 6:26 PM
Hello every one:
I am upgrading to SQL 2005 using sql 2000 datafiles in clustered environment.
I have followd note 799058 hemogenious system copy. However after attaching the database, we are getting the following error message, when running SQL 2005 upgrade tools.
I ran dbcheck on source database there is no issue, However dbcheck is failing in new database. I tried dbcheck with repais fast and dbcheck with data loss, however both attempts have failed with exact same message.
I am not sure how to handle this error.
Please advice.
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
select (@@microsoftversion / 65536) / 256
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
select count(*) from master..sysdatabases where name = 'R3T'
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
select count(*) from R3T..sysusers where name = 'r3t'
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
select count(*) from master..sysprocesses where dbid = db_id('R3T') and program_name like 'R3%' and uid = (select uid from R3T..sysusers where name = 'r3t')
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
select (@@microsoftversion / 65536) / 256
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
DECLARE @n NVARCHAR(4000) DECLARE @ns NVARCHAR(4000) SET @ns = ''
DECLARE c CURSOR FOR
select case when serverproperty('Collation') is NULL then '' else convert(sysname, serverproperty('Collation')) end
union all select case when serverproperty('Edition') is NULL then '' else convert(sysname, serverproperty('Edition')) end
union all select case when serverproperty('InstanceName') is NULL then '' else convert(sysname, serverproperty('InstanceName')) end
union all select case when serverproperty('IsClustered') is NULL then '' else convert(sysname, serverproperty('IsClustered')) end
union all select case when serverproperty('IsFullTextInstalled') is NULL then '' else convert(sysname, serverproperty('IsFullTextInstalled')) end
union all select case when serverproperty('IsIntegratedSecurityOnly') is NULL then '' else convert(sysname, serverproperty('IsIntegratedSecurityOnly')) end
union all select case when serverproperty('IsSingleUser') is NULL then '' else convert(sysname, serverproperty('IsSingleUser')) end
union all select case when serverproperty('IsSyncWithBackup') is NULL then '' else convert(sysname, serverproperty('IsSyncWithBackup')) end
union all select case when serverproperty('MachineName') is NULL then '' else convert(sysname, serverproperty('MachineName')) end
union all select case when serverproperty('NumLicenses') is NULL then '' else convert(sysname, serverproperty('NumLicenses')) end
union all select case when serverproperty('ProcessID') is NULL then '' else convert(sysname, serverproperty('ProcessID')) end
union all select case when serverproperty('ProductVersion') is NULL then '' else convert(sysname, serverproperty('ProductVersion')) end
union all select case when serverproperty('ProductLevel') is NULL then '' else convert(sysname, serverproperty('ProductLevel')) end
union all select case when serverproperty('ServerName') is NULL then '' else convert(sysname, serverproperty('ServerName')) end
union all select case when serverproperty('Release') is NULL then '' else convert(sysname, serverproperty('Release')) end
union all select case when serverproperty('Patch') is NULL then '' else convert(sysname, serverproperty('Patch')) end
union all select case when serverproperty('IsSysAdmin') is NULL then '' else convert(sysname, serverproperty('IsSysAdmin')) end
OPEN c FETCH NEXT FROM c INTO @n
WHILE @@FETCH_STATUS = 0
BEGIN set @ns = @ns + @n + ';' FETCH NEXT FROM c INTO @n END
CLOSE c DEALLOCATE c select @ns
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
select IS_SRVROLEMEMBER('sysadmin')
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
select count(*) from master..sysdatabases where name = 'R3T'
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
select count(*) from R3T..sysusers where name = 'r3t'
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
select count(*) from R3T..sysusers where name = 'r3t'
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
use R3T
declare @info nvarchar(2000)
declare @cs nvarchar(100)
declare @tmp nvarchar(200)
declare @rel nvarchar(100)
declare @patch nvarchar(100)
declare @sql nvarchar(2000)
declare schema_cursor cursor for
select name
from dbo.sysusers
where islogin = '1'
open schema_cursor
select @info = ''
fetch next from schema_cursor into @cs
while @@fetch_status = 0
begin
select @info = @info + @cs
select @info = @info + ':'
select @info = @info + cast(count(*) as varchar(20)) from sysobjects where uid = user_id(@cs) and name not in ('dtproperties')
select @info = @info + ':'
select @info = @info + cast(count(*) as varchar(20)) from sysobjects where uid = user_id(@cs) and type = 'U' and name not in ('dtproperties')
if exists(select * from sysobjects where name = 'CVERS' and uid = user_id(@cs) and type = 'U')
begin
select @info = @info + ':1'
select @sql = 'select @rel = RELEASE, @patch = EXTRELEASE from ' + @cs + '.CVERS where COMPONENT = ''SAP_BASIS'''
exec sp_executesql @sql, N'@rel nvarchar(100) output, @patch nvarchar(100) output', @rel output, @patch output
select @info = @info + ':'
select @info = @info + @rel
select @info = @info + ':'
select @info = @info + @patch
end
else select @info = @info + ':0'
if exists(select * from sysobjects where name = 'BC_CVERS' and uid = user_id(@cs) and type = 'U')
begin
select @info = @info + ':1'
end
else select @info = @info + ':0'
select @info = @info + ';'
fetch next from schema_cursor into @cs
end
close schema_cursor
deallocate schema_cursor
select @info
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
use [R3T] select count(*) from sysobjects where name like 'Y%' and type='P' and uid=user_id('r3t')
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
select count(*) from R3T..sysusers where name = 'SAPR3TDB'
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
DECLARE @n NVARCHAR(4000) DECLARE @ns NVARCHAR(4000) SET @ns = ''
DECLARE c CURSOR FOR
select case when serverproperty('Collation') is NULL then '' else convert(sysname, serverproperty('Collation')) end
union all select case when serverproperty('Edition') is NULL then '' else convert(sysname, serverproperty('Edition')) end
union all select case when serverproperty('InstanceName') is NULL then '' else convert(sysname, serverproperty('InstanceName')) end
union all select case when serverproperty('IsClustered') is NULL then '' else convert(sysname, serverproperty('IsClustered')) end
union all select case when serverproperty('IsFullTextInstalled') is NULL then '' else convert(sysname, serverproperty('IsFullTextInstalled')) end
union all select case when serverproperty('IsIntegratedSecurityOnly') is NULL then '' else convert(sysname, serverproperty('IsIntegratedSecurityOnly')) end
union all select case when serverproperty('IsSingleUser') is NULL then '' else convert(sysname, serverproperty('IsSingleUser')) end
union all select case when serverproperty('IsSyncWithBackup') is NULL then '' else convert(sysname, serverproperty('IsSyncWithBackup')) end
union all select case when serverproperty('MachineName') is NULL then '' else convert(sysname, serverproperty('MachineName')) end
union all select case when serverproperty('NumLicenses') is NULL then '' else convert(sysname, serverproperty('NumLicenses')) end
union all select case when serverproperty('ProcessID') is NULL then '' else convert(sysname, serverproperty('ProcessID')) end
union all select case when serverproperty('ProductVersion') is NULL then '' else convert(sysname, serverproperty('ProductVersion')) end
union all select case when serverproperty('ProductLevel') is NULL then '' else convert(sysname, serverproperty('ProductLevel')) end
union all select case when serverproperty('ServerName') is NULL then '' else convert(sysname, serverproperty('ServerName')) end
union all select case when serverproperty('Release') is NULL then '' else convert(sysname, serverproperty('Release')) end
union all select case when serverproperty('Patch') is NULL then '' else convert(sysname, serverproperty('Patch')) end
union all select case when serverproperty('IsSysAdmin') is NULL then '' else convert(sysname, serverproperty('IsSysAdmin')) end
OPEN c FETCH NEXT FROM c INTO @n
WHILE @@FETCH_STATUS = 0
BEGIN set @ns = @ns + @n + ';' FETCH NEXT FROM c INTO @n END
CLOSE c DEALLOCATE c select @ns
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
select IS_SRVROLEMEMBER('sysadmin')
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
DECLARE @n NVARCHAR(4000) DECLARE @ns NVARCHAR(4000) SET @ns = ''
DECLARE c CURSOR FOR
select case when serverproperty('Collation') is NULL then '' else convert(sysname, serverproperty('Collation')) end
union all select case when serverproperty('Edition') is NULL then '' else convert(sysname, serverproperty('Edition')) end
union all select case when serverproperty('InstanceName') is NULL then '' else convert(sysname, serverproperty('InstanceName')) end
union all select case when serverproperty('IsClustered') is NULL then '' else convert(sysname, serverproperty('IsClustered')) end
union all select case when serverproperty('IsFullTextInstalled') is NULL then '' else convert(sysname, serverproperty('IsFullTextInstalled')) end
union all select case when serverproperty('IsIntegratedSecurityOnly') is NULL then '' else convert(sysname, serverproperty('IsIntegratedSecurityOnly')) end
union all select case when serverproperty('IsSingleUser') is NULL then '' else convert(sysname, serverproperty('IsSingleUser')) end
union all select case when serverproperty('IsSyncWithBackup') is NULL then '' else convert(sysname, serverproperty('IsSyncWithBackup')) end
union all select case when serverproperty('MachineName') is NULL then '' else convert(sysname, serverproperty('MachineName')) end
union all select case when serverproperty('NumLicenses') is NULL then '' else convert(sysname, serverproperty('NumLicenses')) end
union all select case when serverproperty('ProcessID') is NULL then '' else convert(sysname, serverproperty('ProcessID')) end
union all select case when serverproperty('ProductVersion') is NULL then '' else convert(sysname, serverproperty('ProductVersion')) end
union all select case when serverproperty('ProductLevel') is NULL then '' else convert(sysname, serverproperty('ProductLevel')) end
union all select case when serverproperty('ServerName') is NULL then '' else convert(sysname, serverproperty('ServerName')) end
union all select case when serverproperty('Release') is NULL then '' else convert(sysname, serverproperty('Release')) end
union all select case when serverproperty('Patch') is NULL then '' else convert(sysname, serverproperty('Patch')) end
union all select case when serverproperty('IsSysAdmin') is NULL then '' else convert(sysname, serverproperty('IsSysAdmin')) end
OPEN c FETCH NEXT FROM c INTO @n
WHILE @@FETCH_STATUS = 0
BEGIN set @ns = @ns + @n + ';' FETCH NEXT FROM c INTO @n END
CLOSE c DEALLOCATE c select @ns
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
select IS_SRVROLEMEMBER('sysadmin')
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
exec sp_configure 'show advanced options', 1
reconfigure with override
exec sp_configure 'xp_cmdshell', 1
reconfigure with override
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
exec sp_dbcmptlevel 'R3T', 90
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
use R3T select count(*) from sysobjects where type = 'P' and uid = user_id('r3t')
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
use R3T
declare @name sysname
declare allnames cursor for
select name from sysobjects
where type = 'P'
and (name like 'Y%' or name like 'SAP%')
and uid = user_id('r3t')
open allnames
fetch next from allnames into @name
while (@@fetch_status =0)
begin
exec ('drop procedure [r3t].[' + @name + ']')
fetch next from allnames into @name
end
close allnames
deallocate allnames
-
[Microsoft][ODBC SQL Server Driver][SQL Server]Attempt to fetch logical page (6:78) in database 5 failed. It belongs to allocation unit 71905451171905536 not to 281474979397632.
-
executeSQL is called with following parameters:
Server: cacgcbcrr518
Login: integrated security
Resultset will not be copied
Ignore errors is false
Append results is false
-
use R3T select count(*) from sysobjects where type = 'P' and uid = user_id('r3t')
-
executeSQL is called with following parameters:
THIS IS THE SQL ERROR LOGS:
2008-05-28 15:49:20.79 spid21s Starting up database 'R3T'.
2008-05-28 15:49:20.79 spid20s Starting up database 'msdb'.
2008-05-28 15:49:20.82 spid20s 1 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
2008-05-28 15:49:20.84 spid20s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
2008-05-28 15:49:20.84 spid20s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2008-05-28 15:49:20.88 spid21s Analysis of database 'R3T' (5) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
2008-05-28 15:49:20.90 spid21s 1 transactions rolled forward in database 'R3T' (5). This is an informational message only. No user action is required.
2008-05-28 15:49:21.06 spid21s 0 transactions rolled back in database 'R3T' (5). This is an informational message only. No user action is required.
2008-05-28 15:49:21.06 spid21s Recovery is writing a checkpoint in database 'R3T' (5). This is an informational message only. No user action is required.
2008-05-28 15:49:21.06 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
2008-05-28 15:49:21.06 spid5s Recovery is complete. This is an informational message only. No user action is required.
2008-05-28 15:49:25.60 spid51 Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
2008-05-28 15:49:25.74 spid51 Using 'xpsqlbot.dll' version '2005.90.3042' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2008-05-28 15:49:25.81 spid51 Using 'xpstar90.dll' version '2005.90.3042' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2008-05-28 15:49:25.82 spid51 Using 'xplog70.dll' version '2005.90.3042' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2008-05-28 15:58:29.52 spid53 Setting database option SINGLE_USER to ON for database R3T.
2008-05-28 15:58:29.52 spid53 Setting database option SINGLE_USER to ON for database R3T.
2008-05-28 15:59:15.77 spid53 Error: 605, Severity: 21, State: 3.
2008-05-28 15:59:15.77 spid53 Attempt to fetch logical page (6:72) in database 5 failed. It belongs to allocation unit 71905451171905536 not to 281474979397632.
2008-05-28 15:59:15.78 spid53 DBCC CHECKDB (R3T, repair_fast) WITH all_errormsgs, no_infomsgs executed by sa terminated abnormally due to error state 5. Elapsed time: 0 hours 0 minutes 18 seconds.
2008-05-28 16:02:17.43 spid54 Error: 605, Severity: 21, State: 3.
2008-05-28 16:02:17.43 spid54 Attempt to fetch logical page (6:72) in database 5 failed. It belongs to allocation unit 71905451171905536 not to 281474979397632.
2008-05-28 16:02:17.44 spid54 DBCC CHECKDB (R3T, repair_allow_data_loss) WITH all_errormsgs, no_infomsgs executed by sa terminated abnormally due to error state 5. Elapsed time: 0 hours 0 minutes 10 seconds.
2008-05-28 16:04:53.26 spid54 Setting database option MULTI_USER to ON for database R3T.
2008-05-28 16:04:53.26 spid54 Setting database option MULTI_USER to ON for database R3T.
2008-05-29 00:00:06.31 spid15s This instance of SQL Server has been using a process ID of 2016 since 5/28/2008 3:49:21 PM (local) 5/28/2008 10:49:21 PM (UTC). This is an informational message only; no user action is required.
2008-05-29 09:45:59.67 spid54 Error: 605, Severity: 12, State: 3.
2008-05-29 09:45:59.67 spid54 Attempt to fetch logical page (6:72) in database 6 failed. It belongs to allocation unit 71905451171905536 not to 281474979397632.
2008-05-29 09:45:59.69 spid54 DBCC CHECKDB (R3T) WITH no_infomsgs executed by sa terminated abnormally due to error state 5. Elapsed time: 0 hours 1 minutes 20 seconds.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Error: 605, Severity: 12, State: 3
This usually means that you have to recover the database.
Also the fact that DBCC CHECKDB do not run (Error state: 5) indicates database error.
Can't you upgrade to SQL-2005 first
(point 6 in OSS # 799058),
and then attach the database (point 8 in OSS # 799058)?
or am I getting this completely wrong ?
You are talking about a "source database" is it possible for you to make another copy of that source database (I think the actual copy went wrong) without loosing anything ?
Otherwise, if you have been running the database in the Cluster for a while (adding important data), the only way to get back is via restore from a backup.
In that case (added important data), there's no other way than restore.
Hi,
The steps are correct. That's the way I do it.
Somebody might say that you do not need to detach the database.
It is correct that you can simply stop SQL Server and then copy the files.
But, In my mind, the risk for somebody else to start SQL Server by mistake is there so an detach is better in this case.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.