This depends solely on the type of business you are in. I am curious as to the level of auditing as well. Can you clarify the goals you are looking...

Look at these articles. There are a series here with tips. Microsoft also has tools available

www.sqlteam.com/item.asp?ItemID=9066

David.

Hello all,

I have solved this problem. The problem was caused by the timing of the backup. As it turns out there was an additional full backup in an automated job...

One of the things you can try is to look at the RESTORE HEADERONLY COMMAND of the files to see how SQL has marked the file header. Are you using...

This depends on the switch, but in most cases both need to be set as rudy suggests. Some switch manufacturers like ADTRAN allow for 100 MBs Full, but request users...

Thanks. 248 GB is a big database! Do you do anything special on the backup or are you using SQL agent to perform the backup?

David.

Adam,

As stated you do not need to stop SQL to take a backup, however, if the database you take is large the users may see a performance hit if you...

What makes this more perplexing is that the files look good. I am really not sure what SQL is trying to indicate with a 3136 error. I believe SQL is...

I am using INIT for the backup.

Yes, I have with no luck. I get the same error.

I also looked at restore headers only and the file types look OK.

I am unsure of how to...

As a followup my restore command is as follows:

USE MASTER

RESTORE DATABASE [acuity_sys] from Disk=N'F:\FTProot\SQLBackup\Acuity_sys_full_backup.bak' with norecovery, move 'acusydb70data' to 'F:\Acuity_sys_data.mdf', move 'acusydblog' to F:\Acuity_sys_log.ldf'

I then try to restore the differential

RESTORE...

No. The server was not shut off. I thought about that as well. But no.