Data file and log file separation (system databases)

Last Post 14 Jun 2006 03:49 AM by river1. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
river1
New Member
New Member

--
14 Jun 2006 03:49 AM
Hi there
My name is Pedro

Michael Eschenburg gave me a good solution for my problem of how to create a separated log and datafile plan

Thank you very mutch for the reply.

I have understood your solution.
But i still have one question.
You told me that wiith existing databases(user databases) i can for exemple do a attach/reatach, but what about the system database as the master, how can i make the separation between the datafile and the log file , because in the case of this databases I can not do a attach/reatech?

Must be with the restore option?


Best Regards,

Pedro Ribeiro


Acceptable Use Policy
---