transaction log backup - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

transaction log backup

Author

Topic

vicki
Posting Yak Master

117 Posts

Posted - 2002-02-08 : 09:15:37

Any one please show me how to back up the trasaction log please, I look at the book online and here is query to excute it then I tried that but it didn't work

BACKUP LOG docs
TO docs_log1
GO
-----
P.S. docs is my database

Thanks

JustinBigelow
SQL Gigolo

1157 Posts

Posted - 2002-02-08 : 09:46:36

Has the docs_log1 backup device already been created? What is the specific error message you got?

Justin

vicki
Posting Yak Master

117 Posts

Posted - 2002-02-08 : 10:12:09

Thanks Justin,

Yes I did created the docs_log1 and here is the error message

Server: Msg 3206, Level 16, State 1, Line 1
No entry in sysdevices for backup device 'docs_log1'. Update sysdevices and rerun statement.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources