1
  • Need help setting Transaction Log properties in SQL Server 2000

    I'd like some help determining what would be the best settings for my transaction log properties. When our SQL Server 2000 SP4 Database was setup it was done by developers without detailed information regarding all of the possible settings so most settings were left at their defaults. I have been...

    KansasCoder40 pointsBadges:
  • Switching from Bulk-Logged to Simple Recovery Model on SQL Server 2000

    Hello, I've got a SQL Server 2000 SP4 database that I am considering switching from Bulk-Logged to Simple recovery model. The reason is, there are no transaction log backups happening so the log is just growing to an unmanageable size (40+ GB). I also want to minimize/shrink the log file. What is...

    John09905 pointsBadges:
  • Shared folder server activity

    What would be the best way to log data for files in a shared directory (and sub-directories) on a server? The type of information needed would be something like this: - File accessed - By whom the file was accessed - Date/Time opened - Date/Time closed (if possible) - Date/Time file saved...

    Memonboys45 pointsBadges:
  • The purpose of an “undo” file in SQL Server

    I performed a full backup on a development database (Full Recovery Model) in SQL Server, made some changes, backed up the transaction logs, made some more changes and backed up the transaction logs again. Now, when I restore the database using WITH STANDBY, it puts the database into a read only...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error ID 1023 from IMAP4SVC every couple minutes

    I keep getting errors in the logs every few minutes with the description "Error 0x80070003 occurred while rendering message 0001-000000003ab3 for download for user xxxxx@xxxx.xxx." I've only received this error for two different users. Restarting doesn't work, and in the very little resources I...

    Jenrzzz420 pointsBadges:
  • URGENT-REQUIRE INFO REGARDING MS EXCHANGE 2007 TRANSACTION LOGS

    Hi, I am a Log Analyst and iam corrently working on MS excahnge 2007. I require Info regading transaction logs. I have the following queries: 1. What sort of information is written in the transaction logs? 2. I am aware that they are present in binary format. Is there any tool or some way to...

    Yvats10 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following