my development machine. I don't want to restore the transaction logs
(there are two) because they are far too large and are unnecessary for
what I'm doing. I would be happy to simply create one new log in my
development environment. Therefore, I backed up the database using
the No_Log option as in
backup database CPTS to disk = 'd:\backups\cpt s_backup_billeh .bak'
with no_log
I took the backup file and I'm able to restore it on my development
machine with
RESTORE DATABASE [CPTS] FILE = N'CPTS_Data' FROM DISK = N'D:\archives
\Citrix\CPTS\Su pportingMateria ls\cpts_backup_ billeh.bak' WITH MOVE
'CPTS_Data' TO 'd:\databases\C PTS.mdf', MOVE 'CPTS_Log' TO 'd:
\databases\CPTS _log.ldf', MOVE 'CPTS_1_Log' TO 'd:\databases
\CPTS_1_log.ldf '
Note that I cannot additionally specify FILE = N'CPTS_Log' or FILE =
N'CPTS_1_Log' because I get an error.
The restore created the CPTS_Data file only and returned the message
The database cannot be recovered because the log was not restored.<<>>Processed 415664 pages for database 'CPTS', file 'CPTS_Data' on file 1.
What additional step should I take to create a log file? I thought
that No_Log was supposed to give me a truncated log file but it didn't
seem to do so.
Is there another way around this problem? I tried taking the the
resulting mdf file and attaching it using sp_attach_singl e_file_db but
this didn't work either.
Thanks,
Bill E.
Hollywood, FL