--FULLDATABE BACKUP RESTORE DURUM DA KALACAK SEKILDE RESTORE EDILIR RESTORE DATABASE [CHECKDB] FROM DISK = N'C:\hede\CHECKDB.bak' WITH FILE = 1, MOVE N'CHECKDB' TO N'C:\SQLDATA\CHECKDB.mdf', MOVE N'CHECKDB_log' TO N'C:\SQLDATA\CHECKDB_1.ldf', NORECOVERY, NOUNLOAD, STATS = 10 GO --LOG DOSYALARININ RESTORE EDILMESI RESTORE LOG [CHECKDB] FROM DISK = N'C:\hede\CHECKDB_backup_2013_06_27_121355_8145200.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 10 GO RESTORE LOG [CHECKDB] FROM DISK = N'C:\hede\CHECKDB_backup_2013_06_27_121500_7109360.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 10 GO ------restore durumundaki databse'i online cek RESTORE DATABASE [CHECKDB] WITH RECOVERY
