Thanks to all.

Here is what I want to achieve and may be you can provide me a better way: We are buying a SQL product which will using some tables....

You an try these:

use madison

BACKUP LOG madison WITH TRUNCATE_ONLY

go

use madison

go

dbcc shrinkfile (madison_log,400)

go

Take the db backup after these commands.

Thanks. Sanjay

Thanks for the update.

Actually its documented as bug# 810885. But they did not mention any solution.

I have seen other people also facing same issue, but nobody mentioned any solution.

Thanks. Sanjay

...

Thanks for the info. Actually both the servers are SQL 7.0 (SP4). The error message that I got is: SQL-DMO (ODBC SQL STATE 42000) and it states "The database you...

Thanks for the info. Actually both the servers are SQL 7.0 (SP4). The error message that I got is: SQL-DMO (ODBC SQL STATE 42000) and it states "The database you...