1
  • How to recover the deleted database using transaction log file?

    Hello all u witty people! I am working for a pvt. corporate company. We are using Windows 2003Server as our OS and SQL Server. Earlier this morning, i was taking the back up and as my hard disk ran out of space, so it showed me an error message stating that there was not much space. but by then, my...

    Kalyan20088745 pointsBadges:
  • Is it safe to delete SQL Server Transaction Log?

    In one point, I create two Transaction Log for a database, and now I want to delete the second Transaction Log in order to free more space. I just want to get ride of the second file. Is it safe to delete it? SQL Server allow me to do it from DATABASE PROPERTIES WINDOW, but I want to make sure that...

    Vahemelikian10 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:
  • SQL Server Transaction Logs

    If I change the recovery model on the primary database from full to simple and then change the primary database back to full again. Would that break the log chain? It seems the log shipping breaks after we do that.

    Rick Martinez585 pointsBadges:
  • Transaction Log – SQL Server 2005

    How do i find out what transaction log file was last applied to a database?

    0 pointsBadges:
  • Transaction log for read only database…

    Hello there, I am currently studying for the 70-432 (MCTS SQL Server 2008 I&M) exam and I am using Microsoft 70-432 Training Kit by Mike Hotek. At some point the book claims "when a database is placed in READ_ONLY mode, SQL SERVER removes any transaction log that is specified for the database....

    Dallasfb15 pointsBadges:
  • Trouble backing up our SQL Server transaction logs

    Our SQL Server transaction logs have not been backing up, and I discovered it’s because a database was not selected in the maintenance plan. When I select the database and save it, however, it is not saving. It keeps reverting back to the previous option. Does anyone know why?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Scheduling a Shrink Database in SQL Server 2000

    Is there a way to schedule a shrink database after the transaction log has been backed up for a database via the maintenance plan?

    Jauner5 pointsBadges:
  • Facing a problem while working with transactions

    I m having my SQL server on Machine A and i m starting one transaction on server from Machine B, now in between suppost Transaction from Machine B creates a new record in one of the table on server using insert into statement, after creating the record the LAN connection of Machine B is...

    Rajratna5 pointsBadges:
  • SQL Server 2000/2005 Transaction Logs

    Quick Ques. Are transaction logs cummulative? If I have a database set to Full recovery mode; database being backed once a day and transaction logs being backed up hourly, if the database needs to be restored, can I just restore the last transaction log file? Will the last transaction log file...

    JCDBA20 pointsBadges:
  • SQL 2005 Transaction Logs

    I am by no means very good at SQL. I know the basics. I am a network engineer but was recently asked to do a few tasks in a SQL 2005 environment. I currently have a database that is residing off-site and I was asked to import the database and transaction logs so that this server can be used for...

    Danyluk15 pointsBadges:
  • Looking for a stored procedure to monitor size of Transaction Log file

    Is there any way I can create a stored procedure which will check for the Transaction Log file size - where we have a specified limit to grow - and if the Log file reached 80 percent of total size, email alerts can be sent to DBAs?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to control SQL Server transaction log growing to a maximum size

    Transaction log in SQL Server getting completely growed to maximum size frequently even when it is being backed-up and shrinked.. Please provide early and feasible solution.. What is the possible cause for the growth of transaction log to that extent.. and how to avoid it...

    1909198110 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