Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to on backup log
Message
General information
Forum:
Microsoft SQL Server
Category:
Backups
Title:
How to on backup log
Miscellaneous
Thread ID:
00766846
Message ID:
00766846
Views:
44
Besides the maintenance plan wizard which I've put into action, how with query do I execute a backup of log?

I try:

backup log mydatabase to mydatalog with TRUNCATE_ONLY

but it doesn't like the mydatalog part.

something about sysdevices does not recognize the mydatalog.

TIA
Next
Reply
Map
View

Click here to load this message in the networking platform