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: