| Using "SQL Server Management Studio" | |
| To change the location using "SQL Server Management Studio" (requires that the SQL instance is running as a service): |
| 1. | Open "SQL Server Management Studio", and connect to the desired server. |
| 2. | Open a new query, copy the Change File Location text into the query pane, and execute the query. (Change the path as required.) |
| 3. | Open "Services" (Control Panel -> Administrative Tools), and stop and then start "SQL Server (Xxx)". ('Xxx' is the instance name.) |
| 4. | In "SQL Server Management Studio" open a new query, copy the Report File Location text into the query pane, and execute the query. |
| 5. | Verify the new file locations in the physical_name column. |
|
No comments:
Post a Comment