In Prerequisties iam installing MSDE2000A.
Iam Having a Database Backup in
Files and folders>Application Folder>ProductName>Database>database backup file.
I want to resstore the database and the datafiles should be moved to Database Folder in Application Folder.
Thanks
Kiran
Suggested Articles
-
kumarkiranc
- Posts: 85
- Joined: Tue Sep 18, 2007 6:49 am
Hi Kiran,
I'm afraid that I don't fully understand what you are trying to do. Please provide more details.
Regards,
Adriana
_________________
Adriana Simion
Advanced Installer Team
http://www.advancedinstaller.com/
I'm afraid that I don't fully understand what you are trying to do. Please provide more details.
Regards,
Adriana
_________________
Adriana Simion
Advanced Installer Team
http://www.advancedinstaller.com/
-
kumarkiranc
- Posts: 85
- Joined: Tue Sep 18, 2007 6:49 am
Restore
thanx Adriana Simion
in the application folder i have a folder named "DATABASE" which contains backup.bak(my database backup file)
In the Prerequisites i will ask users to install MsDE
Now i want to restore the backup.bak file on their MsDE whick generates me 2(.mdf and .ldf) files .
here i want to set the path that which these two should go and stay in "DATABASE" folder.
hope this gives u sufficient info
thanx in advance
Kiran
in the application folder i have a folder named "DATABASE" which contains backup.bak(my database backup file)
In the Prerequisites i will ask users to install MsDE
Now i want to restore the backup.bak file on their MsDE whick generates me 2(.mdf and .ldf) files .
here i want to set the path that which these two should go and stay in "DATABASE" folder.
hope this gives u sufficient info
thanx in advance
Kiran
Hi,
You can restore the backup by using a SQL script custom action and SQLCMD.exe (from Microsoft).
After the .mdf and .ldf file are created you could try to find them by using the search but I'm not sure if you can figure out their names (which depend on the restore).
If you need them in the folder of your application you can use the result of the search and a custom action to copy them.
Regards,
cosmin
You can restore the backup by using a SQL script custom action and SQLCMD.exe (from Microsoft).
After the .mdf and .ldf file are created you could try to find them by using the search but I'm not sure if you can figure out their names (which depend on the restore).
If you need them in the folder of your application you can use the result of the search and a custom action to copy them.
Regards,
cosmin