InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 04:18:45 GMT20http://www.sqlservercentral.com/Forums/Topic1369402-1550-1.aspxTo 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?Tue, 09 Oct 2012 02:21:52 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic1369402-1550-1.aspx[quote][b]Konuri Dinesh (10/6/2012)[/b][hr]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 stepsstep:1SELECT NAME, PHYSICAL_NAME AS 'PhysicalFilePath', STATE_DESC AS 'DB Status' FROM SYS.MASTER_FILES step:2SELECT 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 serviceStep 4: moved MSDB database to new locationStep 5: started SQL Server service. but i got error 1814 hereGuys could you please help me?[/quote]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. ChandanTue, 09 Oct 2012 01:55:22 GMTchandan_jha18http://www.sqlservercentral.com/Forums/Topic1369402-1550-1.aspxyou 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.Sun, 07 Oct 2012 01:58:40 GMTMac1986http://www.sqlservercentral.com/Forums/Topic1369402-1550-1.aspx[quote][b]Konuri Dinesh (10/6/2012)[/b][hr]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 stepsstep:1SELECT NAME, PHYSICAL_NAME AS 'PhysicalFilePath', STATE_DESC AS 'DB Status' FROM SYS.MASTER_FILES step:2SELECT 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 serviceStep 4: moved MSDB database to new locationStep 5: started SQL Server service. but i got error 1814 hereGuys could you please help me?[/quote]Can you post full details of the error messagesSat, 06 Oct 2012 15:40:39 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1369402-1550-1.aspxDid you move the RESOURCE data base ?Read this it may be of assistance:[url]http://www.mssqltips.com/sqlservertip/1544/sql-server-backup-and-restore-of-the-resource-database/[/url][quote]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.[/quote]Sat, 06 Oct 2012 11:08:20 GMTbitbucket-25253http://www.sqlservercentral.com/Forums/Topic1369402-1550-1.aspxHey 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 stepsstep:1SELECT NAME, PHYSICAL_NAME AS 'PhysicalFilePath', STATE_DESC AS 'DB Status' FROM SYS.MASTER_FILES step:2SELECT 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 serviceStep 4: moved MSDB database to new locationStep 5: started SQL Server service. but i got error 1814 hereGuys could you please help me?Sat, 06 Oct 2012 03:48:08 GMTKonuri Dinesh