Backup Database :
BACKUP DATABASE <DB Name> TO 'C:\' WITH 2 BUFFERS
BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;
Restore Database :
RESTORE DATABASE <DB Name> FROM 'C:\' TAKEN AT <Serial Backup> INTO DB_COPY REPLACE EXISTING;
The Question :
How backup and restore from <asp> ???
Example not Works :
Set Cn = Server.CreateObject("ADODB.Connection")
Cn.Execute "BACKUP DATABASE Data1 TO 'C:\' WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING"
This topic has been locked.
4 replies Latest Post - 2013-03-28T16:29:34Z by SystemAdmin
Pinned topic (Backup, Restore) Database
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-03-28T16:29:34Z at 2013-03-28T16:29:34Z by SystemAdmin
nivanov1 100000H9H753 PostsACCEPTED ANSWER
Re: (Backup, Restore) Database2013-03-27T13:53:00Z in response to SystemAdminBACKUP and RESTORE are not SQL statements, therefore you cannot execute them via ADODB. They are the commands performed by the DB2 Command Line Processor.
You can use the ADMIN_CMD() stored procedure, which you invoke using ADODB, to run these utilities. Details are, as usual, available in the manual: http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.sql.rtn.doc/doc/r0012547.html
Re: (Backup, Restore) Database2013-03-28T07:15:29Z in response to nivanov1Example :
Cn.Execute "CALL SYSPROC.ADMIN_CMD('BACKUP DATABASE DB_MAN TO ""C:\"" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING')"
DB2/NTSQL2413N Online backup is not allowed because the database is not recoverable or a backup pending condition is in effect.
I'm sorry, but i want backup and restore database from my project !!!
I want facility the backup and restore processor in my users !!!
Path Example :
nivanov1 100000H9H753 Posts