Wednesday 13 May 2009

Stored Procedure to move user database files

The following stored procedure allows you to move all files, including any fulltext catalogs, of a specific database.

To run:

I still have yet to add the ability to move files to different locations based on filegroup. Will come later.

No comments: