Database on server but SQLEXPRESS on local machine

Question

This is what I sometimes want:

I have installed on a localmachine sqlexpress. Also my application is installed on the local machine.

But for the night-backup of the database I want to put the database on the company server.

Let's say the database is on: X:\data\mydatabase.mdf

 Why cant't I attach this database with the manager of sqlexpress

 

Second:

I have installed on local machine sqlexpress AND also  the database

Why can't I backup the file to the server like:

BACKUP DATABASE [mydatabase] to DISK=x:\data\mydatabase.bak WITH FORMAT

It looks I can only backup to the localmachine.

 

thanks a lot

Klaas

Answer 1

Hi,

did you try to use the attach the database via any command utility ? SQL Server Management Express is not full featured as its big brother SQL Server Magement Studio. Second: Statements are always sent to the database server to execute. You can´t use any existing mapped drives, though SQL Server Server won´t see them. Use UNC paths instead that can be reached by the SQL Server Services and where the service account has the appropiate credentials on.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Answer 2

Hi Jens,

would you say that it should be possible to have sql-server on a localmachine and the database on a networkserver??

 

thanks again

 

Answer 3

Hi,

no I think you got me wrong here. Putting the datafiles on a (usual) network share is not really a good idea. There are many articles talking about that like [1] . Storing information on a NAS is something different because this is what it is built for reliable network storage, have a look at the KB article of Microsoft to find more information about that: [2]

[1] http://www.mssqlserver.com/faq/general-networkdrives.asp

[2] http://support.microsoft.com/default.aspx?scid=kb;en-us;304261&Product=sql2k

 

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Answer 4

Thanks Jens,

 

this was I was looking for.