I will appreciate an assistance in resolving an issue with sql 2000 server. there was a failure due to power shutdown,and the .mdf and .ldf files on the DB is not longer available. there is a backup done 5days ago with the title nice_cls.BAK. Please how do i restore or reattach the .bak file on the NICE-CLS database. assistance will be appreciated
You are correct. Thank You for your help. will check the link posted .
--RESTORE SCRIPT FOR MOVE DATABASES FROM SOURCE TO DESTINATION
RESTORE DATABASE [DATABASENAME]
FROM DISK ='\\SERVERNAME\DRIVE OR UNC\SOURCE\Backup\DATABASE.bak'
WITH MOVE 'DATABASE' TO 'D:\DESTINATION\DATA\DATABASE.mdf',
MOVE 'DATABASE_log' TO 'L:\DESTINATION\Log\DATABASE_log.ldf'