Thanks all for your valuable reply.

Yes, we are planing to go for Standard edition because of Licensing cost.

Can we backup database from SQL Server 2005 Enterprise edition and use same...

Hi,

Following link may help you...

http://support.microsoft.com/kb/941526

Thanks MysteryJimbo

Yes you are right

I want to store data on central server.

Application from production server should update that data

Both servers should access that data.

Please note, both servers will be on different location.

Thanks for your reply.

But I want to move the database storage from local to central storage.

Please advice.