Thanks for the reply

I have a database with multiple files,

if i restore a file with replace options, is it going to disturb the log.

can u explain with an example where...

Thanks for the quick reply.

actually i am looking to spit my database.

My application has administration (configurations) and functional(business) tables, and want to seperate this out where admin will have access...