This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Delete physical database files
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Jan 14, 2008
04:30 PM
Delete physical database files
Hi,
In my setup package, I use sql scripts to create databases and it went ok. I also have scripts to detach them. However, how can I delete these physical database files?
Another problem is that at the moment I hardcoded the paths for these db files,
for example:
CREATE DATABASE [ASPNETDB] ON (NAME = N'ASPNETDB_471e9d426f5c4adea569c397dcf32bed_DAT', FILENAME = N'c:\pipeline\aspnetdb.mdf' , SIZE = 10, FILEGROWTH = 5) LOG ON (NAME = N'ASPNETDB_TMP_log', FILENAME = N'c:\pipeline\aspnetdb_log.ldf' , FILEGROWTH = 10%)
Is there any chance that sql scripts can take parameters so that the users can choose where to put these db?
Many Thanks
Jerry
In my setup package, I use sql scripts to create databases and it went ok. I also have scripts to detach them. However, how can I delete these physical database files?
Another problem is that at the moment I hardcoded the paths for these db files,
for example:
CREATE DATABASE [ASPNETDB] ON (NAME = N'ASPNETDB_471e9d426f5c4adea569c397dcf32bed_DAT', FILENAME = N'c:\pipeline\aspnetdb.mdf' , SIZE = 10, FILEGROWTH = 5) LOG ON (NAME = N'ASPNETDB_TMP_log', FILENAME = N'c:\pipeline\aspnetdb_log.ldf' , FILEGROWTH = 10%)
Is there any chance that sql scripts can take parameters so that the users can choose where to put these db?
Many Thanks
Jerry
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Jan 15, 2008
12:42 PM
What project type are you using?