set up DB on remote storage

[johncan20]

hi,

How do i set up a DB on remote storage from the SQL server.

i have set up a mapped drive on the server to the NAS but it only allows me to select local drives in enterprise manager when i set up a DB.

thanks

John

 

[DrSql]

I think you cannot create a new db in a remote storgae in SQL Server or any db's. Mapping a network drive wont work. Enterprise Manager only sees your local drives. If your drive is part of SAN then add that to your server and you should be able to create db's. If anyone have any alternate suggestions please correct me.

Dr.Sql
Good Luck.

 

[mrdenny]

Storing database on remote storage isn't supported in SQL Server (and probably never will be). You'll need local storage.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[johncan20]

so you do you do a front end - back end server config?

 

[SQLBill]

so you do you do a front end - back end server config?

That's different. You can do a front end on one system and the back end on another. You CANNOT have the backend on two systems (SQL Server on one system and the user databases on another system).

So, it depends on what you really meant....they answered the question that you asked.

-SQLBill


Posting advice: FAQ481-4875

 

[hgrick]

try enabling Trace flag 1807 on that server

 

[mrdenny]

While that will allow you to put the database on a UNC share it will make the server unsupported. If your network has even the smallest hickup (switch reboots, nic cable gets unplugged, etc) your entire database can become corrupt.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com