Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

sp_add_log_file_recover_suspect_db [ @dbName = ]????

Posted on 2011-10-07
2
Medium Priority
?
555 Views
Last Modified: 2012-05-12
I lost a transaction log because of hardware failure. I've taken an affected DB offline and cannot bring it online. My research points me to the tsql in the title but I'm struggling on how to use it. Can someone post an example.

OR

Is there another way to create a new ldf for an offline DB?

TIA
0
Comment
Question by:Mike Miller
2 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 2000 total points
ID: 36932749
Your Transaction Log backup is an integral part of your database, so your best bet is to restore from a backup.
0
 

Author Comment

by:Mike Miller
ID: 36932771
Oh ok. Thanks!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question