Hi,

Thanks for reply

The error is in Job history failed, where it is restoring in Event viewer properties - Application.

Of course table also is not updating.

Thanks in advance

Karna

Hi all,

I already installed SQL Server 2000 in my System in D:\Microsoft SQL server 2000. Some of the components have been installed in c:\program files\microsoft sql server\.

Now I have to...

Hi all,

My Full Backup Restore code

RESTORE DATABASE Webdeccan

FROM disk = 'G:\Backup\Webdeccan\xxxxxx.BAK'

WITH NoreCOVERY,

MOVE 'webdeccan_data' TO 'e:\SQLServer\MSSQL\Data\webdeccan_data.mdf',

MOVE 'webdeccan_log' TO 'e:\SQLServer\MSSQL\Data\webdeccan_log.ldf'

This is scheduled daily @ 9:10pm called as New Backup

code for Restore differential...

Hi all,

Can anyone tell me the difference & feature between Overwrite & Append mode in SQL Server Backup for Differential & appropriate usage.

Thanks in advance,

Karna