October 6, 2012 at 3:48 am
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?
October 6, 2012 at 11:08 am
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.
October 6, 2012 at 3:40 pm
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" 😉
October 7, 2012 at 1:58 am
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.
October 9, 2012 at 1:55 am
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
October 9, 2012 at 2:21 am
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