Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Quan69
Starting Member
5 Posts |
 Posted - 2012-04-07 : 11:43:06
|
| I get following error messages for this query:Incorrect syntax near the keyword 'TRAN'.Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.Any help would be appreciated?Me |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-04-07 : 15:27:25
|
| It's not altogether clear what you're trying to do.WITH TRUNCATE_ONLY was removed in SQL 2008. And for good reason.BACKUP TRAN library is bad syntax.Have a look here |
 |
|
|
|
|
|
BACKUP TRAN library WITH TRUNCATE_ONLY