A restore database question? - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

A restore database question?

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-10-18 : 09:03:04

writes "dear all:
as title,I have a problem.I want to develop a UI which can Backup DB & Restore DB.Because Our Customer won't use MS-SQL to do that.Now I have already finish a store procedure for Backup but my problem is in restroe,the procedure is under

I want know where I type Error ?

@BkpPath ='c:\Temp\Test.Bak'
-------------------------------------

CREATE PROCEDURE sp_Restore_DB

(
@BkpPath nvarchar(256)
)
AS

RESTORE DATABASE [FALSDB] from DISK= @BkpPath WITH RECOVERY,REPLACE

Best Regard
Leo Lin"

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-10-18 : 09:43:20

...the procedure is under what?

What error?

Jay White
{0}

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources