Database Back Up - 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)

Database Back Up

Author

Topic

vicki
Posting Yak Master

117 Posts

Posted - 2002-02-28 : 10:46:20

This is the way how I do the back up database:
Right click on the DB--> All taks --> Back up DB, but the Trasaction Log,File and FileGroup are grey out so I can't click on the radio button. What happend?, how can I make that visible so I can choose whatever I want to back up the database

Thanks alot

Edited by - vicki on 02/28/2002 10:56:08

izaltsman
A custom title

1139 Posts

Posted - 2002-02-28 : 11:12:53

You can't take log and filegroup backups when your database is in SIMPLE recovery mode (SQL2k) or has "trunc. log on chkpt." option set (SQL7) or if you have never done a full backup of the database.

vicki
Posting Yak Master

117 Posts

Posted - 2002-02-28 : 11:45:49

Thanks, it's worked after I changed to Full mode..

What is the diffrences b/w Full, Simple and Bull-Logged?

Thanks

Edited by - vicki on 02/28/2002 11:50:02

Edited by - vicki on 02/28/2002 11:51:55

Edited by - vicki on 02/28/2002 11:52:29

chadmat
The Chadinator

1974 Posts

Posted - 2002-02-28 : 11:58:45

Read:

"Selecting a Recovery Model"

From Books Online.

-Chad

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources