1
  • Database and Log file location

    How do I change the default location for database and log files during a SQL 2005 installation?

    Quincy185 pointsBadges:
  • 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:
  • SQLCMD does not create a log file

    I have several SQL update/delete statements I run during a payroll cycle. When I run a SQL that does not have any records that meet the selection criteria, I do not get a log created. I can run the same SQL in SQLServer, and it shows (0 records updated).

    Harv200250 pointsBadges:
  • Log of stored procedures run on my SQL 2005 box.

    How can I tell who ran which stored procedure on our SQL 2005 server and at what time? Can we see if one stored procedure called other stored procedures there as well? Can we enable verbose logging somehow as well for more data?

    Karl Gechlik9,860 pointsBadges:
  • Changing over to DR database from SQL 2005

    I have set up log shipping from my production SQL2005 databases to my DR server and all seems to be working fine. On examing my DR databases they are all in (Restoring...) mode.  How do I now access my DR databases if/when my production system goes down?  There does not seem to be any obvious...

    Swales1015 pointsBadges:
  • Full vs Transaction Log Backups

    Is it nessisary to perform a log backup on a database that is set to Full recovery if I am uninterested in doing a point in time restore? I could opt for Simple, but, really my question is, why? My question also goes on to the size of the ldf file, and will it reuse space and not have to grow if I...

    Jagoodie60 pointsBadges:
  • Converting a log file in C#

    how to convert a log file in text format into sql database

    Riyapavithravarsha5 pointsBadges:
  • SQL Log files

    Can I delete a SQL log file

    RSCC5 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