Login or Sign Up
- Logging in...
  
  Remember me
  
  Or
  
  Sign Up
  
  Forgot password or user name?
- Log in with

Search in titles only Search in posts by ttcdr only

Advanced Search

Forums
BYTES
Product Launch
Updates
Developer Toolkit

Today's Posts
Member List
Calendar

Home
ttcdr

User Profile

Collapse

Profile Sidebar

Collapse

ttcdr

Last Activity: Sep 19 '07, 06:57 AM

Joined: Sep 18 '07

Location:

Subscriptions2
Subscribers0

Activities
About
Media
Subscribed

Time

All Time Today Last Week Last Month
Show

All Discussions only Photos only Videos only Links only Polls only Events only
Source

All ttcdr only Visitor Messages Only Advanced

Filtered by:

new posts

ttcdr started a topic Change from Full Recovery to Simple Recovery Mode?

in SQL Server

Sep 18 '07, 08:28 AM
Change from Full Recovery to Simple Recovery Mode?

We have MS SQL 2000 server, the log file of our Database growth to 23G.

If I change the database from Full Recovery mode to Simple Mode, the log file should shink. Am I correct???

And how do I do that? Am I just:
Enterprise Manager --> right click the database --> properties --> Change the recovery from "Full" to "Simple"???

Thanks a lot

See more | Go to post
ttcdr replied to SQL Problem. The log file for database...

in SQL Server

Sep 18 '07, 08:11 AM
How do I truncate the log?

Thanks a lot.

See more | Go to post
Leave a comment:

No activity results to display

Show More

Bytes
Help
Contact Us
Privacy
Terms of Service
Go to top

All times are GMT. This page was generated at 1 minute ago.

Working...

👍

👎

☕