Jump to content

about Restoring of the crashed database after upgrade from 6.4 to 6.5


RandyWang

Recommended Posts

hi 

2.Delete all stored procedures, functions, views from your era_db. Use the following sql syntax to delete all stored procedures, functions, views

EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL' 
declare @sql varchar(max)='';

select @sql=@sql+'DROP VIEW '+name +';' from sys.views;
exec(@sql);

EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL' 
declare @sql varchar(max)='';

select @sql=@sql+'DROP Function '+name +';' from sys.objects o where type='TF';
Exec (@sql);

EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL' 
declare @sql varchar(max)='';

select @sql=@sql+'DROP PROC '+name +';' from sys.procedures;
exec(@sql);

but run the script according to your database type. It recreates all stored procedures in era_db,show this message

訊息 2714,層級 16,狀態 3,程序 ufn_uuid_str_to_binary,行 11
There is already an object named 'ufn_uuid_str_to_binary' in the database.
訊息 2714,層級 16,狀態 3,程序 ufn_uuid_str_to_id,行 16
There is already an object named 'ufn_uuid_str_to_id' in the database.
訊息 2714,層級 16,狀態 3,程序 ufn_create_hour_interval,行 4
There is already an object named 'ufn_create_hour_interval' in the database.
訊息 2714,層級 16,狀態 3,程序 ufn_create_day_interval,行 4
There is already an object named 'ufn_create_day_interval' in the database.
訊息 2714,層級 16,狀態 3,程序 ufn_interval_2,行 13
There is already an object named 'ufn_interval_2' in the database.
訊息 2714,層級 16,狀態 3,程序 ufn_interval_4,行 15
There is already an object named 'ufn_interval_4' in the database.
訊息 2714,層級 16,狀態 3,程序 ufn_interval_6,行 17
There is already an object named 'ufn_interval_6' in the database.

May be a data table is not deleted?

Restoring of the crashed database after upgrade from 6.4 to 6.5
The procedure for debugging should be performed after 6.4 to 6.5 or before upgrading

Thank you for your reply

 

 

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...