Problem With Moving MSDB?

  • 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?

  • Did you move the RESOURCE data base ?

    Read this it may be of assistance:

    http://www.mssqltips.com/sqlservertip/1544/sql-server-backup-and-restore-of-the-resource-database/

    You can also try moving the master database on a different location without moving the Resource database together with it and you will not be able to start the service.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • 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?

    Can you post full details of the error messages

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • you might want to be a little careful while playing around with sys databases. If msdb is not online and you recycle the SQL services, your tempDB will also be not created because validations and procedures to build TempDB again are all in MSDB only.

    Please let us know what were the error logs when you moved the mdf and ldf files.

    I would say restore the .bak file with move option it would easy.

  • 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?

    Please post entire error logs from eventviewer from that time stamp. Often this is related to security because the service account might not have permission on the new location. Please post all the logs from that time stamp.

    Chandan

  • To which location you moved the files?? Are they the same location where tempdb files resides?

    After moving to the new location are you sure you have sufficient space under that drive?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply