.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Hard drive crashed - no backup - Files saved, cannot attach sql db

Posted By:      Posted Date: October 27, 2010    Points: 0   Category :Sql Server


the people called me in their firm because server Won't boot-up (SQL 2000).

I checked it and it was hard drive failure. Manage to get DB data from HD, i wanted to put it on SQL 2005 on new machine.

I successfully attached 5 databases, they are working now, but have problem with 6th. When i trying to attach it get the error;

Server Name: PROMET
Error Number: 9004
Severity: 21
State: 1
Line Number: 1

.mdf file has 1.3 gigs and .ldf 6.1 gig

I searching trough the forums all day, and i cannot find working answer...

Please help me, i can provide additional information if needed.

View Complete Post

More Related Resource Links

Delete Old Backup Files that are saved in .RAR format



I have configured my SQL Server 2005 to take backups and I have another program running to compress these files to .RAR extension to save space.

I have a Maintenance Cleanup Task also configured to delete old .RAR files but it does not work.  I have specified the extension to look for to be RAR and the job runs without error but no files are deleted.

Is it that only BAK and TRN files are deleted using Maintenance Cleanup Task?

Toolbox: Easy File Backup, Exploring Files And Folders Inside Visual Studio, Multiple Monitor Softwa


If the responsibility for creating, managing, and executing routine backups is yours, these tools will make it easier. Also see how you can browse folders and files from inside Visual Studio.

Scott Mitchell

MSDN Magazine May 2009

Why does .NET Framework require 841 MB hard drive space on C:

Just downloaded .NET Framework 4 from Microsoft website. Installation says it requires 841 MB space on my C: drive. Why so much? I am presuming that this is in addition to the space for the other versions of .net installed. This is not going to be installed without a very good reason for this much space required. Can anybody enlighten me on this? Any way to lighten the space requirement load?  

Sql Server 2005 backup misses files

I have a SQL Server 2005 database that contains 3 files.  Sometimes when I run rhe backup, it appears to only backup 2 of the three files.  The only way I can get it to return to a full backup is to restore the database from a backup tape.

Autodelete log files on L: drive

Is there a way to automatically delete sharepoint logs on the server L: drive when space fills up?  I keep getting mom alerts on this drive.

How to attach distribution database files

Hi  i am new to sql server. when i am exploring replication concepts, i did a small mistake i.e. i have deleted distribution database.after that i realised and try to create a new one but it still points to the old database named as "distribution" which is not available. i didnt take the backup of the database before dropping. But i have mdf and ldf files of the distribution database. so can i use the sp_attach method to add the  mdf and ldf files? or any other way to fix this issue? please help me on resolving this issue Thanks, Rock  

Unable to access VM network drive in SQL during backup generated by stored procedure

I get the following error in a log file created in the osql command: Msg 3201, Level 16, State 1, Server KAC2KGS2, Procedure usp_Kaman_Full_SqlDB_Backup, Line 150Cannot open backup device 'x:\Servername_master_sqlbu_200703101930.bkf'.Device error or device off-line. See the SQL Server error log for moredetails.Msg 3013, Level 16, State 1, Server KAC2KGS2, Procedure usp_Kaman_Full_SqlDB_Backup, Line 150BACKUP DATABASE is terminating abnormally. The device is established in a CMD file right before the osql command is started that starts my stored procedure.  The CMD in this file is: for /f "tokens=15 delims=." %%i in ('ipconfig^|find "IP Address"^|find "192.168"') do set SUBNET=%%i :loopif exist x:\ net use x: /delnet use x: \\192.168.%SUBNET%.1\backup if not ERRORLEVEL 1 ( goto continue) else ( echo FAILED TO CONNECT TO BACKUP SERVER >> "%SystemDrive%\LogFiles\%Computername%.log" sleep 60 goto loop) :continue echo IP ADDRESS OBTAINED Echo delete old log file if it exists if exist %3\%computername%_kaman_full_sqldb_backup_old.log del /Q %3\%computername%_kaman_full_sqldb_backup_old.log Echo Rename log file to old.log rename %3\%computername%_kaman_full_sqldb_backup.log %computername%_kaman_full_sqldb_backup_old.log echo backup SQL Databases on server will start now osql -E -n -d %1 -i %2\kaman_full_sqldb_backup.sql -h-1 -o %3\%Co

SQL Server Specs of Hard Drive

Hi, Is there a SQL Server script that gives information about a hard drive, like the size of the Hard Drive, Free space and how much of the hard drive is used?

workflow starts before files are saved?


I have a sharepoint designer workflow associated with a document lib. The workflow is triggered when a new item is created or modified. The workflow will update attributes of the item.

The problem comes that for small files, the workflow works. For bigger file (even 0.5 mb), either the workflow failed to update the item or the file was saved as 0 byte.

Any recommendations?

Custom Workflow Error: The Workflow files were saved but cannot be run


Hi all,

I'm wondering if someone would have any suggestions on how I can troubleshoot this custom workflow issue.

Recently we can't attach any SharePoint Designer workflow to any list in a farm. We get this error message:

"Errors were found when compiling the workflow. The workflow files were saved but cannot be run. Unexpected error on server associating the workflow"

The standard workflows from UI seems to be working fine. Also user defined workflow is enabled. In the past I was able to fix similar issue with another farm following this post (remvoing SP designer custom workflow activities entries)- but does not look like this is the case this time.

Nothing in the logs regarding this error. Any suggestions would be greatly appreciated.

Many thanks!


hard drive space


Does anyone know the minimum space required on the install partition so that the analyzer does not throw any warnings? 
We are strapped for space and the recommended 80 GBs is not a option for us.

Thanks in advance.

log files doesn't clear after full backup


I have SQL 5 and for some odd reason log files doesn't clear after Full back up.  I have to manually shrink the log files.

can someone explain what could be wrong

Attach files in anonymous mode



how can i attach files to sharepoint list in anonymous mode.

I want to attach a file to sharepoint list in anonymous mod but ask me a username and password. please help me to attach files without entering username and password.


copy a folder and subfolders + files from remote location to local drive



i am making a windows application( C#.Net) in which there is a folder placed at remote location( on other computer). this folder contains files + subfolders inside it. i need to copy all the files and subfolders present inside this main folder to my local drive. How can i do this. 

Thanks in advance

Not able to attach or restore northwind.mdf and northwind.ldf files



I downloaded nothwind.mdf and nothwind.ldf  files from the net.when I try to attach any of these files, i am getting the error as "Unable to open the physical file "d:\northwind.mdf".Operating system error5. 5 Access is denied.

Can you please help me to resolve this issue?

returning backup files to applications


Hi all.

I want to send a backup command to sql server and return backup file to my c# application.

sql server is another machine and I have not access to its hard disk.

What should I do for that?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend