Error after moving system databases

Question

Post reply

Error after moving system databases

Viewing 10 posts - 16 through 24 (of 24 total)

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

PiMané SSChampion Points: 13965 More actions · Answer 1

I described what I did...

The ALTER DATABASE statement with MODIFY to change the location of the files...

That's exactly what I did...

First to tempdb, restart, SQL Server OK!

Then to model and msdb, restart, SQL Server gave the error I posted before, ERRORLOG file.

It wasn't a question of permissions since the tempdb was moved with success.

Pedro

If you need to work better, try working less...

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

After running the ALTER DATABASE command and shutting down SQL Server, did you move the mdf and ldf files to their new locations before starting SQL Server again?

PiMané SSChampion Points: 13965 More actions · Answer 3

No. Should I've done that? Doesn't SQL does it auto like it does with tempdb?

Or since tempdb is recreated every time SQL starts was the reason it didn't fail?

Pedro

If you need to work better, try working less...

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 4

You should have moved the Files to new locations and that was the reason Gail or I was repeating what / How did you perform....

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

PiMané SSChampion Points: 13965 More actions · Answer 5

ok,

Thanks and sorry for the confusion..

But since these databases aren't very used, they are important but not read/write intensive, there's no need to move the log file to the log RAID, right (like said earlier)?

Thanks,

Pedro

If you need to work better, try working less...

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

PiMané (11/3/2009)
No. Should I've done that? Doesn't SQL does it auto like it does with tempdb?
Or since tempdb is recreated every time SQL starts was the reason it didn't fail?
Pedro

TempDB is recreated each time SQL Server is restarted. In fact, you probably still have tempdb mdf/ldf files sitting in the original location that you can now delete.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

PiMané (11/3/2009)
ok,
Thanks and sorry for the confusion..
But since these databases aren't very used, they are important but not read/write intensive, there's no need to move the log file to the log RAID, right (like said earlier)?
Thanks,
Pedro

As they are system databases, you may want the ldf files on a raid drive as well.

PiMané SSChampion Points: 13965 More actions · Answer 8

@Lynn Pettis

The data files, along with the system databases (data and log), are on a RAID10.

The log files are on a RAID1 and tempdb has a RAID1 of it's own also.

The "safety" of RAID is assured, my only question is if it's worth moving the system databases' log files to the RAID1 for log of user's databases.

I also had doubt if tempdb should be RAID1 or RAID0 (faster for tempdb) since tempdb with our application is very write intensive and SQL rebuilds it every time it starts... But the "safety" of RAID1 is better... who knows maybe latter more 2 disks and upgrade RAID1 to RAID10...

Pedro

If you need to work better, try working less...

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

PiMané (11/3/2009)
@Lynn Pettis
The data files, along with the system databases (data and log), are on a RAID10.
The log files are on a RAID1 and tempdb has a RAID1 of it's own also.
The "safety" of RAID is assured, my only question is if it's worth moving the system databases' log files to the RAID1 for log of user's databases.
I also had doubt if tempdb should be RAID1 or RAID0 (faster for tempdb) since tempdb with our application is very write intensive and SQL rebuilds it every time it starts... But the "safety" of RAID1 is better... who knows maybe latter more 2 disks and upgrade RAID1 to RAID10...
Pedro

You want tempdb on raid 1 at a minimum. If you used raid 0 and lost a drive your SQL Server would come crashing down.

george sibbald SSC Guru Points: 104210 More actions · Answer 10

PiMané (11/3/2009)
@Lynn Pettis
The data files, along with the system databases (data and log), are on a RAID10.
The log files are on a RAID1 and tempdb has a RAID1 of it's own also.
The "safety" of RAID is assured, my only question is if it's worth moving the system databases' log files to the RAID1 for log of user's databases.
Pedro

it is not worth moving the system database log files to a separate location than the data files, as these databases are comparatively lightly used and to all intents and purposes read only. MSDB might be more heavily used but don't complicate your install any more than necessary.

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