Hi Brian,

Thanks for the inputs. I agree if they are system files which are related to OS and its logical too but if they are program files or tools or...

you can refer this kb article, its about backup but the same logic can be applied to restore too..

http://support.microsoft.com/default.aspx?scid=kb;en-us;q207187

Good luck 🙂

Oops!! It should be "Restore Database" not "restore log"..if u have subsequent transaction logs then u can use Restore Log after Restore Database..

Sorry for the confusion

Andy,

Firstly, you have to check the MSSQL service is started by domain account and then you can simply run this:

RESTORE LOG EPINAV

FROM DISK = '\\Server A\BkupFolder\bkupfile.bak'

WITH RECOVERY

If you...

Thanks for the inputs..But I have used another technique so that I get reliable timestamp everytime i.e. i use a linker server to connect to my source database and get...

Hi Ram,

Are u using a restore script or something that is running on a scheduled basis? if you are maintaining a standby server, then you have to check some things...

I dont think this is a naming convention problem, becoz I checked the backupset table for that particular slot and the backup_Start_finishdate it shows the same time i.e. 3:01pm...Any more...

Thanks for the comments, but its not a part of process which has to run simultaneously on both servers. Actually, this is for a mobile application wherein data from pocket...

I recently came across file backups mentioned in BOL, which allows you to have the tlogs backup going on with file backup..But as per my theoretical knowledge, file backup involves...

Update: I have created one column table[e.g sysparam] in which I store the count of records from tablexyz in Server A and then i match the count and if this...

Ok, I found it. Actually on the server where the database is being restored, theres a backupset table which is a replica of the backupset table of the originating server...

Ok I understand, Snapshots can be used as a combination with the existing complete backup and tlog backup in DR strategy but cannot be used as the only solution and...

Yes, the second option was causing the trouble. Thanks again.

Dilip

Thanks!

Actually, this was coming due to overlapping restores. Im looking into this and will update u with the detailed error if it comes next time.

Regards,

Dilip

Jason,

Thanks for the inputs..I had another look in backupset table, actually it takes avg. 56 mins not 2 hrs to complete the backup of 31 GB database. I will try...