Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amitkumarmadhukar
Starting Member
45 Posts |
 Posted - 2004-08-12 : 08:08:06
|
| Hi Guys,Please Tell me Either,Can i Use Dlls to Populate Restore Wizard from Visual Basic in to MSSQL7/MSSQL2000OrAny Executable files by which Restore Wizard can be executed in to MSSSQL7/2000amit kumar madhukar |
|
|
ruan4u
Posting Yak Master
132 Posts |
Posted - 2004-08-12 : 08:17:56
|
| did u try SQL DMO.it helps u call SQL Enterprise through VB |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-08-12 : 08:18:24
|
| you can use tsql for restore process,but why do you need to populate the wizard? |
|
|
|
amitkumarmadhukar
Starting Member
45 Posts |
Posted - 2004-08-12 : 08:50:15
|
| tsql command not found.or there is no file with name of tsql in SQL7's installation directory. from where i can able to get and the answer of ur question why i need to populate restore wizard from my application written in VB then actually i have multiple Backup file in certain directory and i want to give all the backup files to the user according to date and time to select and restore as per his desired like SQL Enterprise Manager give me from Server-Datebase-ALL Tasks List-Restroe Datebase WizardCan u help me i am also looking for any dll which can referenceable into VB and i can use its restore method if exits.amit kumar madhukar |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-08-12 : 09:27:26
|
| tsql means transact sql. This is the flavor of SQL that SQL Server uses. You execute tsql using tools like query analyzer, isql and osql.Look in books online (BOL) for the backup/restore commands. There will be examples of how they are used with the above mentioned tools.-ec |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-08-13 : 10:59:04
|
| I see, so is this what you want to do?1. Create a GUI that is similar to enterprise manager, ofcourse limited to restore process?2. You have a repository of database backup files***you can execute sql statements like restore (check BOL) in vb e.g.connObject.execute "[sql statement]", just remember that sql statements use single quotes for strings instead of double quotes.Have fun :) |
|
|
|
|
|
|
Restoring With Dlls