Rick Toner
3/22/2007 7:05:00 PM
I use this and it works every time:
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name =
N'DataBaseName')
begin
ALTER DATABASE [DataBaseName] SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE
DROP DATABASE [DataBaseName]
end
GO
RESTORE DATABASE DataBaseName
FROM DISK = 'C:\Directory\DataBaseName.bak'
WITH MOVE 'DataBaseName_Data' TO 'C:\Directory\\DataBaseName.mdf',
MOVE 'DataBaseName_Log' TO 'C:\Directory\\DataBaseName_log.ldf'
GO
--
Rick Toner
"MV" wrote:
> Hi, I have to restore daily databases that are still in use, I can drop
> connection without problem but I'm searching a way to scripting this step,
> is there a way to drop connection, restore db via TSQL Script ? Thanks
>
>
>