Hi,

Backup database <<DB Name>> to disk='d:\foldernmae\backupfilename.bak'

and press F5

sethu

Thanks,

I don't know deepak. So without compatability change, system doesn;t generate transaction logs. Is't?

If i need transaction log, i can change all the stored procedures based on sqlserver2005 compatability.Am i...

Thanks Deepak,

If i change compatability level is 80 or 90, do i change any SQL statements inside stored procedure cas i have created lots of stored procedure 7.0 compatability. Without...

Thanks all,

Actually .TRN file is not generated when i set sql server7.0 compatability set to sql server 2005 database. when i open to view sql server7.0 database to sql server...