Put SQLSERVER .MDF file on other CPU

[PankX]

Hi all,

can I create a database and put the MDF file on other CPU ?

i have a File server removable drive and want to put the mdf file there. any idea ??

Thank's

 

[onpnt]

That would be highly not recommended. You add in network contention and usage into the mix of your database servers performance. I'm not really sure why you would even want to do that.

[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]

 

[ptheriault]

By default you can not create databases on mapped or UNC network location. If you insist on this course of action you would have to start SQL Server with trace flag 1807. But as onpnt has already pointed out, it's a very bad idea.

- Paul
- If at first you don't succeed, find out if the loser gets anything.