ALTER DATABASE knukonceptzsql
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE
RESTORE DATABASE knukonceptzsql
FROM DISK = 'C:\knukonceptz\knukonceptzsql.bak'
WITH MOVE 'knukonceptzsql_Data' TO 'C:\knukonceptz\datafile.mdf',
MOVE 'knukonceptzsql_Log' TO 'C:\knukonceptz\logfile.ldf',
REPLACE


ALTER DATABASE knukonceptz
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE
RESTORE DATABASE knukonceptz
FROM DISK = 'C:\knukonceptzsql.bak'
WITH MOVE 'knukonceptz' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\knukonceptz.mdf',
MOVE 'knukonceptz_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\knukonceptz_log.ldf',
REPLACE