restore question

I use sql2000/sp3 in w2k/sp3,if i can
restore a database from a net device direct(not copy the
bak file to local disk)?I think you want to do something like this
RESTORE DATABASE FROM DISK = '\\ServerName\ShareName\FileName'
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"peng" <zhoupeng1971@.yahoo.com> wrote in message
news:022d01c35cbd$68fde570$a001280a@.phx.gbl...
> I use sql2000/sp3 in w2k/sp3,if i can
> restore a database from a net device direct(not copy the
> bak file to local disk)?|||Hi Peng,
Make sure that the SQL Server Startup service account has the permission to
access the network for this to work.
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Restore Newbie

I am trying to install and run a prototype VB.net application for review
I have desktop edition of SQL2K installed and running.
I have a .bak file that I need to load for the applications data
How do I do restore?
I've seen posts where one runs the restore command, but I cannot find an executable called restore.exe?Allan,
It's a T-SQL command.
RESTORE DATABASE.
Or, you can do it from Enterprise Manager.
Either way, look at RESTORE DATABASE in Books Online.
James Hokes
"Allan" <anonymous@.discussions.microsoft.com> wrote in message
news:E467A676-703B-4636-BAE0-19B4BB6DD55B@.microsoft.com...
> I am trying to install and run a prototype VB.net application for review
> I have desktop edition of SQL2K installed and running.
> I have a .bak file that I need to load for the applications data
> How do I do restore?
> I've seen posts where one runs the restore command, but I cannot find an
executable called restore.exe?
>
>

restore MSSQL BAK file by TSQL

Hi,

I need an application with asp.net that let me restore database by getting .bak file and database name and database user and user password, my database is SQL Server 2005.

There is an open source one named

Database Publishing Services 1.1

Google it or search Microsoft site about it

HTH
Regards