Forum Discussion
Ajit_Kulkarni
20 years agoLevel 6
Hello,
As per your post, you want a SQL Script to be executed.
Please refer the below mentioned procedure:
This script can be executed using the OSQL utility that gets installed along with Backup Exec. Please refer the following steps to run the script:
------------------------------------------------------
Create one file called sql.txt containing following,
select ScriptID from Scripts where ( ScriptName like ''Duplicate%'' ) and ( ScriptType = 300 )
begin delete from SetCopyScriptEntries where ScriptID = ScriptID end delete from Scripts where ScriptName like 'Duplicate%' commit transaction
--------------------------------------------------------------
1. Create a text file for the SQL script named Sql.txt on the root of C: (where C: is the drive where Backup Exec is installed)
2. Go to the Command Prompt.
3.Change directories to C:\Program Files\Microsoft SQL Server\80\Tools\Bin Folder on the media server.
4.Run the following command:
osql -S \bkupexec -dbedb -E -i C:\sql.txt
NOTE: The computer name is the media server name and "<>" are not to be included in the command.
-----------------------------------------------------
For more information on the OSQL Utility please refer the following link:
http://www.di-mgt.com.au/osqlUtility.htm
Hope this helps you.
Regards,
NOTE : If we do not receive your reply within two business days, this post would be marked "assumed answered" and would be moved to "answered questions" pool.
As per your post, you want a SQL Script to be executed.
Please refer the below mentioned procedure:
This script can be executed using the OSQL utility that gets installed along with Backup Exec. Please refer the following steps to run the script:
------------------------------------------------------
Create one file called sql.txt containing following,
select ScriptID from Scripts where ( ScriptName like ''Duplicate%'' ) and ( ScriptType = 300 )
begin delete from SetCopyScriptEntries where ScriptID = ScriptID end delete from Scripts where ScriptName like 'Duplicate%' commit transaction
--------------------------------------------------------------
1. Create a text file for the SQL script named Sql.txt on the root of C: (where C: is the drive where Backup Exec is installed)
2. Go to the Command Prompt.
3.Change directories to C:\Program Files\Microsoft SQL Server\80\Tools\Bin Folder on the media server.
4.Run the following command:
osql -S
NOTE: The computer name is the media server name and "<>" are not to be included in the command.
-----------------------------------------------------
For more information on the OSQL Utility please refer the following link:
http://www.di-mgt.com.au/osqlUtility.htm
Hope this helps you.
Regards,
NOTE : If we do not receive your reply within two business days, this post would be marked "assumed answered" and would be moved to "answered questions" pool.
Related Content
- 4 years ago
- 8 years ago