Hi,

Could you please provide solution, plz provide syntax.

Regards,

Pradeep.

use data_sample

BACKUP DATABASE DATA_SAMPLE TO DISK='E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\DATA_SAMPLE.BAK'

RESTORE DATABASE DATA_SAMPLE FROM DISK='E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\DATA_SAMPLE.BAK' WITH NORECOVERY

ERROR MESSAGE:

Msg 3102, Level 16, State 1, Line 1

RESTORE cannot process database 'DATA_SAMPLE'...

Hi,

i saw ur message, i have a got problem, my problem is i have create one database, i take backup but restore database got problem.

Ex:

iam creating one database like sample_database.

i...

Hi Pradeep gi,

Thz for sending mail, but u have send one link not yet openend , what should i do pradeep gi.Could plz give some guidences gi.

Regards,

Pradeep.