| SQL SERVER 2005 HELP [message #446250] |
Sun, 07 March 2010 02:07  |
asadkhan_2
Messages: 36
Registered: January 2008
|
Member |
|
|
@echo off
CLS
REM ********************************
SET V_USER=riyadh
SET V_PASSWORD=riyadh
SET V_DB=vis
SET V_DMP_PATH=D:\dump\
REM ********************************
ECHO.
SET EXP_PATH=D:\oracle\visdb\9.2.0\bin\
SET MONTH=%DATE:~4,2%
SET YEAR=%DATE:~10,4%
SET DATED=%DATE:~-7,2%
ECHO ECHO CONNECT AS : %V_USER%/%V_PASSWORD%@%V_DB%
ECHO Backup on : %DATED%/%MONTH%/%YEAR% (DD/MM/YYYY)
ECHO SAVE AS : %V_DMP_PATH%%V_USER%_%DATED%%MONTH%%YEAR%.dmp
ECHO TITLE BACKUP ...%V_USER%_%DATED%%MONTH%%YEAR%
echo.
%EXP_PATH%EXP.exe %V_USER%/%V_PASSWORD%@%V_DB% file=%V_DMP_PATH%%V_USER%_%DATED%%MONTH%%YEAR%.dmp log=%V_DMP_PATH%%V_USER%_%DATED%%MONTH%%YEAR%.log
i am executing the above script successfully in oracle but i have one sql server database also can anyone tell me wat changes should i need to run this script on sql server 2005 i know its not relevant here but if anyone can help will be thankfull
thanks a lot
|
|
|
|
| Re: SQL SERVER 2005 HELP [message #446252 is a reply to message #446250] |
Sun, 07 March 2010 02:45  |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Yes it is not relevant to an Oracle forum to answer SQL Server question, why don't you post it in SQL Server forum?
The policy here, described in OraFAQ Forum Guide, you should read, is to lock such topic.
So it is.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
