Icon Frequently Asked Questions

How do I change the path of a defined database after a database has been moved to a different location ?

You can use the ALTER DATABASE statement to do so:

ALTER DATABASE <DatabaseName> PATH <NewPath>
Image