Deleted Mdf File
Sep 20, 2007
I am currently trying to recover a data base that i detached. I have search the computer with *.mdf with out results...
I detached the database from msde 2000 and then installed sql express now when i go to attach the db it is missing, is there away i can recover the db?
View 8 Replies
ADVERTISEMENT
Apr 1, 2002
Hi All
The problem is
The transaction file of Database got deleted.So Sql server shows the Db as suspect.Unfortunately also do not have latest bk up copy of DB.
I tried creating dummy log file with same name and placing it in same location but that did not help.
I wud highly appreciate if someone cud suggest a soln quickly.
Warm Regards
Jignesh
View 1 Replies
View Related
Mar 21, 2008
hi,is it possible to retrieve deleted data from .log file in sql server 2005 ? ThanksMayur Panchal
View 1 Replies
View Related
Jul 20, 2005
Hello,A utility I was running caused our database's log file to run out ofhard drive.So, I detached the database, deleted the log file, and tried toreattach.SQL server fails to reattach because it cant find the log file. (Whyit cant just create a new default one is beyond me...but...)EXEC sp_attach_single_file_db @dbname = 'sgvault',@physname = 'c:Program FilesMicrosoft SQLServerMSSQLDatasgvault.mdf''Could not open new database 'sgvault'. CREATE DATABASE is aborted.Device activation error. The physical file name 'C:ProgramFilesMicrosoft SQL ServerMSSQLdatasgvault_log.LDF' may beincorrect.Do you know how I can fix this dilemma? Thanks!
View 2 Replies
View Related
Jun 14, 2001
Hi All,
In SQL Server 2000(Sql Query Analyzer), I had opened a main program file for debugging purpose.
Somehow by mistake its entire contents get replaced/deleted.
I don't have the backup.
I would appreciate anyone who can save me by advising to restore this program.
View 4 Replies
View Related
Feb 27, 2008
I'm using an ASP.net /SQL server Configuration to run a small database site for my company,
I have broken the database...darn
I had 4 databases in the SQL list and decided since 3 of them showed no subfolders what so ever and SQL would not let me open them saying
"you haven't got enough space on the disk or the files your trying to access don't exist" -- I'm paraphrasing but that's about the jist of it. I decided they didnt do anything and to delete these DB from the list (to be honesty i dont even know if this is what caused the problem to start with)
what i did then was register a root database, this database is the database (i believe) is used to query and store results (from the asp.net), it was located at
C:XXXXXXsecureJobBrokerDB
once i added this and found it did seam to be where the website data was coming from. i deleted two of the entrys in the SQL object Explorer that showed me the error "you haven't got enough space on the disk or the files your trying to access don't exist" i now realise this must have been a big mistake since after i removed this the system let me login but didnt let me do anything else, it alowed me to browse the pages but didnt let me query any of the DB side of the application, What have i done and how can i restore it? (we have no official backup, we do have a MASTER and A TEST DB registered in the object explorer which contain copys of the DB)
i had one idea can i use the web.config section <connectionString> to make the web site look toward either The Master OR TEST copys of the DB
<connectionStrings>
<add name="classifiedsConnection" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|standguidedb.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
</connectionStrings>
will this solve my problem if i edit this entry to point to another DB thats identical to the old one
View 3 Replies
View Related
Jun 29, 2015
I have a publisher database set up for a merge replication. This is using parameterized filter with join filters.
I also have a stored procedure that does deletes & inserts on the table where the parameterized filter is applied to aid in changing a subscriber's eligibility to receive so and so data. I have observed that running the stored procedure takes extraordinarily long and as a result, the log file grows to a size 1.5 - 2.5 times the database size.
At first I reasoned that this might because I had it set up to use precomputed partitions and changing it requires recalculating the partitions. As a test, I turned off the precomputed partitions. Didn't work. I turned on "optimize synchronization" AKA "keep_partition_changes", which normally is not available when you have precomputed partition on, and that didn't work, either.
At this point, I think I can rule out precomputed partitions being a problem here but I'm stumped now what else I should do to reduce the amount of log writes being required. We do need the parameterized filters & join tables, so that can't go.
View 0 Replies
View Related
Nov 19, 2007
Hi,
The standby file (.tuf file) got deleted accidentally on the secondary. How can I recover the database without the standby file?
View 3 Replies
View Related
Sep 27, 2007
I just did the dumbest thing ever. I think I have lost my database. i was trying to attach a different db with the same name. but it wasnt able to attach so the i renamed my current db and attached the new db.i dont know what has happened but my old db has been deleted and i cant find it the mdf file for it.... that has been removed for the directory it was in too!! I was using MS SQL Server Managemnent Studio can I undo this somehow?? PLEASE HELP
View 14 Replies
View Related
Dec 11, 2000
Is it possible to know that who has deleted the database
Thanks in advance
View 2 Replies
View Related
Jan 21, 2005
Our past CIO deleted a SQL Server database because he didn't know what it was or if we needed it. Guess what we do! We were able to undelete the backup files but when we try to restore from it we get the error "No a valid backup" Any ideas?
Thank you for any help. :eek:
View 2 Replies
View Related
Jul 25, 2006
I am running sql server 2000 on windows 2000. i have my backups set to delete after a week. they are not deleting, can anyone tell me why this is happening?? the backups filled the hard drive.
View 3 Replies
View Related
Apr 18, 2007
Is there anyway to retreive deleted data (rows) of a table? Unfortunately the backups are corrupt so we can't do a restore.
Thanks
View 12 Replies
View Related
May 18, 2007
Hi,
I accidentaly deleted a package while working on it, intention was to delete another package just above it in solution explorer but the one i was working on got deleted, is there any way to retrieve it...??
any suggestion wud be appreciated.
thanks,
ravi
Nothing much that i can do..!!
View 5 Replies
View Related
Jul 23, 2005
I am runnnig Microsoft SQL Server 2000 and have a database that getsdownloaded everymorning from an ftp site. This download contains thenew records and any changes to existing records. However I am runninginto a problem in that I am forced to recreate the views over everytimewe replace the new database with the old one. I've tried restoring thedatabase as well as replacing it and am not sure what I am missing. Iam new to SQL Server and any help would be greatly appreciated.
View 4 Replies
View Related
Jul 20, 2005
Any ideas how I can recover a job that has been deleted (?) from SQL7.0 ? We had one which was used on a regular basis which has nowceased to exists. I've spoken to the people responsible for the serverand was met by blank faces (as usual). They have no idea when it wasdeleted, by whom or when. To make matters worse, they don't think theycan get it off the backup set without a major bit of work to theserver. Suprisingly, none of the users noticed that things had stoppedworking.Unfortunately, I needed to do some work on this in preparation for mymonthly meeting with my boss on Monday. Whilst I'm not to blame, I'dlike to understand a little more about any options available to us forrecovery as he will undoubtedly ask when he finds out.I have an old back up on another server, so it's not the end of theworld re-creating it, but I was under the impression it was backed upproperly. Is this normal or have they missed something ?Are there any ways I can recover this ? What can I get done to thebackup to make sure this is backed up properly ?Thanks in advance.Ryan
View 1 Replies
View Related
Jul 20, 2005
Dear All,I got a wierd problem which I haven't been able to explain.I am working on MS SQL 2000. I don't know for what reason, therelationship between Parent/Child table is getting deleted. When Iopen up the ER diagram in MSSQL Enterprise Manager, I see therelationship line come up for just a split of a second, and disappearsafterwards. This is the second time I am seeing this thing.I realized it when I accidently deleted the rows in the Parent Table.They should not have been deleted as I had associated records in theChild Table (because of Key Constraints).Has anyone ever come across this situation? Do you have anysuggestions?Regards,TinTin
View 1 Replies
View Related
Feb 5, 2008
hi,
I have deleted the mastlog.ldf file how can I restore it?
thanks
View 14 Replies
View Related
Feb 1, 2008
5 accounts have access to database, is it possible to see or log who deleted any records?
Thank you
View 4 Replies
View Related
Sep 17, 2007
I am using this code to delete records from a table in the database that has two fields (both are primary keys) I am not getting any error, but nothing gets deleted. Thanks for the help.
Code:protected void btnRemove_Click(object sender, EventArgs e)
{
Remove();Response.Redirect("RegisteredCompanies.aspx");
}protected void Remove()
{
//update database with filename
//Save Changes
connection.Open();using (SqlTransaction trans = connection.BeginTransaction())
{
try
{ SqlHelper.ExecuteNonQuery(trans, CommandType.StoredProcedure, "spRemoveCompany", new SqlParameter("@Userid", getGdUserID(Profile.UserName)),new SqlParameter("@BusinessID", getBusinessID());
}catch (Exception err)
{
// throw exception
trans.Rollback();
lblStatus.Text = "An error has occurred in the delete process. Please try again.";
}
}
Here is the stored procedure:ALTER PROCEDURE [dbo].[spRemoveCompany]
@Userid uniqueidentifier OUTPUT,
@BusinessID uniqueidentifier OUTPUT
ASDELETE FROM Associations2 WHERE Userid = @Userid AND BusinessID = @BusinessID
RETURN
View 4 Replies
View Related
Dec 15, 2007
Hello, Can I reuse the deleted primary key id? I'm using SQLServer2005. cheers,imperialx
View 6 Replies
View Related
Mar 4, 2004
Hi,
I am currently working on a MS SQL server 2000.
I would like to access the data inserted or deleted within a trigger. however the built-in tables -- inserted and deleted --- are not accessible. anyone knows why? And is there any other way to do this?
Thanks
View 1 Replies
View Related
Mar 27, 2004
I have stoopidly enough deleted default Db. That causes Enterprise Manager to be unable to work with my DB's. The default DB I deleted had no other functions other then being default DB, I mean it was outdated, and I had other DB's that contained all my importent work. They are still running, and I can view DB driven site hosted at localhost, even though default DB no longer excist. I am even able to upload new content, or add new users, so this means all my other DB's are fine. I can even see SQL server icon in my bottom right corner of my desktop, and it shows server running.
Now I am in the need of adding tables and rework some of my excisting tables and stored procedures, but I am not able to do that with Enterprise Manager, due to the lack of default Database.
How do I correct this problem? I have gotten one tip of doing the following: EXEC sp_defaultdb 'User', 'DB' but I am not sure what to do with this.....tried to run it from command line, and put my username and the DB I would set to default but nothing happend.
So I need more details, step-by-step guiding will work, as I don't know a hole lot about Enterprise Manager and SQL.
Btw, this is my error in Enterpr.Managr:
A connection could not be established to MyComputerVSDOTNET2003
Reason: Cannot open default database. Login failed..
Please verify SQL server is running and check your SQL server registration prpoerties and try again
Pls tell me there is a way to fix this problem.
View 6 Replies
View Related
Dec 6, 2004
hi there,
by mistake i deleted tables in the DB, i heard once that there is a way to retireve it after it has deleted, from the temp or something like that
so is there a way?
Thanks
View 1 Replies
View Related
Mar 12, 1999
When I try to link tables from Access97 to SQL7, all the columns have #deleted# in them. Does any one know why this is?
Thanks
Phil
View 3 Replies
View Related
Mar 22, 2005
I want to know what to do to recover the deleted records on a specific table. Unfortunately, the dba was unable to activate Trace feature and I am not familiar in using the transaction logs to retrieve data.
please help. :confused:
View 4 Replies
View Related
Mar 28, 2006
I created an alert (18453) to audit successful logins. After I was done with the alert I made I edited the alert 18453 to disable event log logging and then deleted the alert. My problem is that the alert is deleted but it continues to log to the SQL Server error log and the windows application log. I have tried restarting the SQL Server Agent and even had the server rebooted over the weekend. Has anyone else had this problem? Where is this configured and how can I disable it?
View 2 Replies
View Related
Sep 21, 2001
Does anybody know if SQL 2000 has a tool to roll back (udelete) records?
Let's say Payroll dept deletes 500 records by mistake...
I know of 2 products that do that (Computer Assoc. - Unicenter Log Analyzer
and Red Matrix Techmologies' SQL Audit 1.7 - but I have never used them. Any comments? Thanks for your help.
View 2 Replies
View Related
Feb 20, 2005
Hi everyone
Is there any way to recover all deleted records.
By mistakes i deleted all records.
Please help me out
Waiting for reply.
Thanx in advance
View 2 Replies
View Related
Nov 8, 2005
Subscription data are deleted...
We've got a merge replication. I have one Publisher and one Subscriber. I've made a pull subscription to a Publisher.
I've got into trouble few times occasionally 3-4 times a year. Today also I got problem with one table only one row among so many not carried out on at subscriber, even it is not find out at publisher.
This row was entered at subscriber in the morning, printed by users but in evening report it is not coming down in reports, so I had checkup and find out it is not available at any server. How?
I don’t understand, how inserted, printed data erase from subscriber but rarely. Is there any clue?
Which parameter of the subscription is responsible for it ?
Best regards.
View 2 Replies
View Related
Dec 12, 2005
Hello All.
Is there a way to check who has deleted records from my SQL tables? I asked because I notice records keep disappearing from my tables recently for no reason. The DB is only accessible by a few IT staff. Business users have no direct access to it so they can't do any harm and there is no application that update these record missing tables.
I don't need to know the exact records that have been removed. I need info on who has made a deletion activity on which table, date and time is good enough.
Thank you.
Best regards
View 5 Replies
View Related
Dec 28, 2005
If I have an Identity-declared column, the table has lots of rows and I start deleteting records - will any old, deleted identities be re-used (without an explicit re-seed) ?
(I'm talking about numerical Identities, not these GUID things)
View 2 Replies
View Related
Feb 1, 2006
How do we get the number of rows deleted from a table?
@@rowcount is returning 0
View 2 Replies
View Related