Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


How to restore database MSSQL 2005 SP4?

How to restore database MSSQL 2005 SP4?

How to restore database MSSQL 2005 SP4?

How to restore base after RAID crash? I hoped to restore using Backup, but very late noticed that the Backup was not done. Now how do I restore the database on MSSQL 2005 SP4, which is marked with Suspend?

RE: How to restore database MSSQL 2005 SP4?

Use master
sp_configure 'allow updates', 1
reconfigure with override
select status from sysdatabases where name = 'DataBaseName'
EXEC sp_resetstatus 'DataBaseName';
alter database DataBaseName set EMERGENCY, SINGLE_USER
dbcc checkdb ('DataBaseName', REPAIR_ALLOW_DATA_LOSS)
alter database DataBaseName set ONLINE, MULTI_USER
Use master
sp_configure 'allow updates', 0
reconfigure with override
P. S. If in the end "dbcc checkdb" to swear on something that can't create log file then create the folder that it asks for and repeat the operation with this item again (if the base stood in other place earlier).
In that case, if this way cannot restore a database, then use the Recovery Toolbox for SQL Server. It often helped out me.
It is possible to found additional councils and recommendations on this resource

RE: How to restore database MSSQL 2005 SP4?

Thank you!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


White Paper - Understanding Critical Specifications for Dynamic Metrology Applications
Different types of metrology have different critical specifications to consider when determining which actuator technology to use. This white paper goes into detail on the demands of dynamic metrology applications as they apply to the selection of precision linear motion control components and systems. In addition, the relevance of Moore's Law is examined in the context of the industry. Download Now
White Paper - Permanent Non-Welded and Cold Bent Piping Solutions
Commonly used welded piping connections come with skilled labor, validation, inspection, and long commissioning times, as well as the workplace hazards associated with welding. Non-welded permanent mechanically attached fittings offer a viable alternative to welded piping systems that greatly reduces the time to commission piping systems through reductions in many of the time-consuming steps required in welding. Download Now
White Paper - Take Mobile Hydraulic Systems to a New Level
The introduction of digital ecosystems connecting electronic control hardware and software to the Cloud is catalyzing a new era of mobile machine and equipment design innovation. This is enabling OEMs across industries to develop customized solutions that digitally integrate hydraulic and machine controls with the Internet of Things (IoT). Download Now
White Paper - The Evolving Landscape of Commercial Battery-Powered Trucks
What’s driving the evolving landscape of truck electrification? What are the barriers, motivators and strategies for accelerating the electric transition? What insights and resources are available for today’s design engineers working to achieve industry disruption and evolution? For answers to these and other pertinent questions, read this white paper. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close