If you want just start the server then you need master database is enough.

if you want more services like agent services,db mail services etc. then you need model and MSDB...

Performance wise, like you already assumed, absolutely there is no benefit to having multiple log files.

Chalapathi Pagidakula

SQL-DBA

Thanks Jeff Moden the problem solved.

Hi Praveen,

I had given those permissions also,still it was showing same error, please help us.

thanks & regards

Chalapathi

Hi durai nagarajan,

ya exactly its a named instance i have given the windows path also

like \\192.168.0.21\foldername at that time i am getting

error: the...

Hi All,

I have restore Problem in Log Shipping, the copy job succeed but when i see the restore...