April 16, 2007 at 2:06 pm
When am trying to restore a bakup file it kicks an error saying that I can not acess the file, when I checked it at the bakup file location it is not existing there but I wonder why does it shows up in the file group list of restore when there is no file in there actually.
April 16, 2007 at 2:45 pm
When you backup a database to a file, SQL Server 'records' that information. It does NOT keep checking to make sure the information has stayed the same. So if the file is then deleted or moved, SQL Server does not have a record of that.
Sometimes a database will be backed up to a drive and then copied to tape. Once it's on tape, the disk copy can be deleted. But SQL Server still thinks it is on disk. So to restore, you first have to copy the backup from tape to the disk location and then RESTORE it. This is a way to save disk space.
-SQLBill
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply