Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
How to create the database files under a specific path
설명
Can the database files be created under a different path then the SQL default?
해결 방안
When creating a database, the Database Wizard provides the option to select the path where the mdf and ldf files will reside:
On the Enter Database Settings page of the wizard, check Override Default File Locations
Click the ellipsis
The Select Remote Path window will open. Please note, the drive you see are on the SQL server you entered previously in the wizard, not the local drives of where the wizard is running
Select the path you want to use for the Data File Path and the Log File Path
Provide name for the database file and log file. For example ERDatabase_Data.mdf and ERDatagbase_Log.ldf
The paths should look similar to the following: -<drive>\SQL Databases\ERDatabase_Data.mdf - <drive>\SQL Logs\ERDatabase_Log.ldf
