Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RyanSmith
Starting Member
8 Posts |
 Posted - 2008-09-10 : 16:56:23
|
| Here's my issue.I have Management Studio Express installed on a server which I have full access to. The SQL Server instance lives on another server which I don't have any access to except the database that was created there for me (which I have db_owner rights on).I have my .bak file that I want to use to restore the database will all the data, but when I browse for the file, I get the directory from the server which the SQL instance is on (which seems like a security issue to me), not the server that has Management Studio installed.I have looked all around and can't figure out how to get to the local file listing. Any help would be greatly appericated.Thanks,Ryan.http://www.dynamicajax.com |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-09-10 : 17:04:37
|
| You can use a UNC path:RESTORE DATABASE ...FROM DISK = '\\server1\share1\SomeFile.bak'...You can also do this from the GUI screen but be prepared to type it in. Make sure the path is valid first.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
RyanSmith
Starting Member
8 Posts |
Posted - 2008-09-10 : 17:41:04
|
| So I am going to need to setup a share on the machine running Management Studio that can be accessed from the server running the SQL instance?There's no way to access the local files through Management Studio?http://www.dynamicajax.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-09-10 : 17:42:27
|
| The share would be on the machine where SSMS is running, not on the database server. Yes you can access the file on the local machine, but it must be through UNC. Do you have local admin on the local machine? If so, you can use the admin shares, such as C$.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
|
|
|
Management Studio Express - Accessing Local Files