December 27, 2007 at 10:10 pm
To remove out filled transaction logs we use command
dump transaction database_name with no_log
it works properly for other database but it won't work for few database.
It won't work for below db.
ROSE-25-APR07
TPC2-19
is there any spacific database naming convention becoz of which I m failing..
Reply soon
Regards
Majid
December 27, 2007 at 10:17 pm
Hi
Can u tell the specific error that you are getting. you can also check sql logs for more details on the error.
My first take on the naming convention is that it should not be a problem but iam not sure abt this.
"Keep Trying"
December 27, 2007 at 10:54 pm
What's the compatability mode of the databases i works in and the ones it doesn't?
Dump transaction is deprecated in SQL 2005. You should use Backup Log with truncate_only, or, even better, set the DB to simple recovery mode if you don't need point-in-time recoverability. If you do, do proper log backups
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 27, 2007 at 11:33 pm
Showing error message as
dump transaction Rose-25-APR07 with no_log
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '-'.
But it works fine if I change the name of db as Rose_25_APR07
what will be the actual problem?
Regards
Majid
December 28, 2007 at 12:25 am
Try enclosing the DB name in square brackets
dump transaction [Rose-25-APR07] with no_log
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 28, 2007 at 1:49 am
Yes Gail,
It's working..
Thanks a lot..
be always guided to me..
Regards
Majid
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply