Konuri Dinesh (10/6/2012)

---

Hey Pals!

I moved My MSDB database to another location. after that i tried to start my server but unfortunately it can't 🙁

i done it by following steps

step:1

SELECT

NAME,

PHYSICAL_NAME AS 'PhysicalFilePath',

STATE_DESC AS 'DB Status'

FROM SYS.MASTER_FILES

step:2

SELECT

ALTER DATABASE MSDB

MODIFY FILE

(

NAME = MSDBData,

FILENAME= 'C:\SQLDB\Demo\MSDBData.mdf'

)

GO

ALTER DATABASE MSDB

MODIFY FILE

(

NAME = MSDBLog,

FILENAME= 'C:\SQLDB\Demo\MSDBLog.ldf'

)

GO

step:3 Stoped SQL Server service

Step 4: moved MSDB database to new location

Step 5: started SQL Server service.

but i got error 1814 here

Guys could you please help me?