Home » Other » General » SQL SERVER 2005 HELP (windows 2003 server)
SQL SERVER 2005 HELP [message #446250] Sun, 07 March 2010 02:07 Go to next message
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 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Oracle Documentation
Next Topic: Standard Premier Support (Software Update License and Support)
Goto Forum:
  


Current Time: Thu Mar 28 16:26:15 CDT 2024