Hello!
Hopefully someone can help me that i have lost my data on my D: drive.
driven shown all folder but in side of the folder there is nothing.
i have lost my Doc, xls, Jpeg etc. all files.
please help me what sould i have to do.
thanks
HiWhen we issue a DBCC SHRINKFILE with empty option, the data fileis removed and the space is alloted back to the OS.Same way when we issue a an ALTER DATABASE to remove a database,all the data files and transaction log files are dropped.But can these files be recovered again by using any of the diskrecovery tools?Achilles
View 1 Replies View Relatedraju writes "while attaching the mdf file we are getting the following error
error 823
i/o error (bad page id) detected during read at offset
0x0000001404000 in file d:filename"
I wrong delete all contents of a table.
I was going to restore the full backup database but the file is corrupt.
I have:
The last 5 days backups of Transaction Log;
The actual Transaction Log;
Can you please give me any ideas of how to restore de transaction logs backups and/or uncommitted de deletion of all rows of the table.
Thanks,
Paulo
Hi,
I need to receover lost data. My colleague ran a database creation script to create a new database, from Sql Query Analyzer. While doing this, an existing database was selected in the combo box that appears on the top,which led to deletion of records from the existing database. I have a backup of the d.base taken 10days ago. The data was lost yesterday. Is there any way I can restore the database to the previous condition.
Hi, I was wondering after I had deployed my data base on the internet and made some modifications with her, what is the best approach to recover the data base deployed? Now if I'm changing some stored procedure in the data base deployed I have to make the same change in the original data base, it gives me a lot of work.
Thank you very much.
Fell free to correct me if I misspeled something.
Hi,
Let's suppose i am having a table in which i am having 10,000 records, "I d't need the data of the that table" by thinking this i deleteed all teh data of the table. But suddenly after 2-3 days i thought i need that data.
So will i able to recover the data in both cases :
Delete - If i used teh Delete command to delete all teh data of teh table then is it possible to recover the data in teh above condition.
Truncate - Or If i have used the Truncate command to delete the data from the table then is it possible to recover the data in above case.Please tell me , if it is possible in both or any cases then tell me how to recover it. Remeber i am not having any backups of the data.
I want to learn that if my query deleted all data in the table by mistake, is it possible recovery and how?
View 1 Replies View RelatedHi,
Is there any way to restore the old data after changes made to the table.
Suppose i run a query Update CustomerDetails set customerName='Michel' and i forgot to mention the CustomerID whom name should be changed to Michel,in that case in all the CustomerName will update by Michel Name.
So,How can i revert back the changes made to the table?
Thanks in advance.
Regards,
- Hitesh Kumar
Hello!
Hopefully someone can help me with the following (potentially huge) problem:
We've got a simple database application running on microsoft sql desktop engine. This database contains two tables. Up until now all worked fine, but probably due to a programma that crashed part of the database seems to be corrupted or broken while today only one table contains/returns data and the other table does not return any values!
When I open the .ldf and .mdf files in notepad I see that there is data belonging to both the tables. But how do I recover it??
The max. size of the database has not been reached by far (it's only 9Mbs), the sql queries are correct.
This .ldf file is a log file (?) I can't find detailed info about the principles of these .ldf and .mdf files on the internet, is it possible to trace back what has happened en recover the database that way?
Thanks in advance.
Greetings,
Rens Voogd
Hi All,
By mistake i delete database from sql server. Due to which the the mdf and ldf file of the datbase are removed from my system. Then i used file recover utility and retrived my mdf and ldf files.But now i am not able to attach those files into databse. These mdf and ldf files has been corrupted. Now how can i recover my data from those mdf and ldf files.Please answer me if you have any solution on this problem.
Regards,
Satish Rotella
Hello, everyone:
Does any body have the experience to execute data warehouse backup/recover? What I want to know is how to backup/recover database in data warehouse and cubes.
Thanks.
ZYT
Hi all. A few days ago i installed mcafee total protection 2007 and that disabled my internet connection totally!! I couldn't fix it so i had to uninstall it. After uninstalling mcafee total protection 2007 still i couldn't join Internet!!
So i got mad and went and made repair installation of windows xp pro. After repair installation i couldn't activate it since Internet connection was still not working!! So i went and installed another copy of xp pro on different folder and named it WINDOWS (old one was WINDOWS2).Thanks god now i could join Internet but all my shortcuts and menu items are not visible.
Unfortunately I can't even start sql server 2000 either!! could any one tell me what should i do in order to get access to all database tables and data that i had in sql server and make a back up. I didn't install any new sql server yet. I be happy if an expert tell me what should i do. The installation folder of old windows(WINDOWS2) is still available along with sql server installation folder.Thank and looking forward for reply.
I accidentally deleted some useful data in my database. I have both .LDF and .MDF files for this database.
Is there a way to recover this database to a point of time?
Thx.
Dear All,One of our employee made a mistake and deleted something from database.I would like to recover that log file without restoring the backup andthe other log files. The reason I want to do this is our database isgetting real time information I cannot shut down the database. Is thereany way to do this please let me know and help me .Kindly regardsLS
View 2 Replies View RelatedCan I restore records from a MSDE2000 Database
I copied some stored procedure from other database but unfortunately, I drop all records
I have checked the Transaction Log which is only 1024 KB
I have used Red Gate Log Resure but cannot find the log
Anyone can Help!!!!!
Thanks
I used sql 2000 create a data base at home call 'Mysite' several months ago, there are about eight tables and 30 stored procedures. When I run my asp.net program at home yesterday, and found can't connect to database. The error as follow: "Cannot open database requested in login 'Mysite'. Login fails. Login failed for user 'MINGYANG-MSONXHASPNET'. "
When I open the database, very surpriced to found that my database was suspect and not any item inside it. The suspect database include CommunityStarterKit. But Northwind and pubs database still there?
What happen? Last week I just download new Norton antivirus software, does have any relationship with it? Does data really gone? How to solve this problem?
Please help me if you have these experience.
We lost all the data we had in a table. We restored the db and the transaction log up to a point in time, but could still not recover the table. We eventually only do db restore without the transaction log. We recovered the data in the table in question, but lost all the data entered that particular day. Does any body have a solution or suggestion that can help? I will be greatly appreciated.
View 2 Replies View Relatedthis morning, one user asked me that she entered a data (only one record,)on the database yesterday, but later she checked that is gone, I check the database, i am sure the data is now there. how do i retrieve the data back, or how do i know whehter this is user problem? Thanks in advance
View 2 Replies View RelatedHi Guru,This weekend, I migrated SQL Server7.0 to 2000 and below is thescenarios:1.) At exactly 4:00PM on Sturday 17th, do full backup(T-SQL) and put adatabase into single user mode.2.) Copy both Saturday 4PM and Friday night full dump to the SAN.3.) Delete WinNT4.0.4.) Reinstall Win2003 and service pack3a.5.) Copy Saturday 4PM backup file to the server and do restore and douser ID mapping.This database is in full mode and I do log backup every hour. However,after restoring the database, any changes after the 14th were missing.Now, When I restored Friday night backup, we still recovered data tothe 16th. My question is, why the 17th 4PM backup did not copy anychange from 15th to the 17th Saturday?I still had Sturday backup file, howe can I recover the 17th data? Logexplorer or ApexSQLLog?Is this Disk issue?Thanks very much,Silaphet,
View 1 Replies View RelatedHi,
I have encountered problem in the merge replication with conflict caused by foreign key constraint. As I did some reseach that it can be avoided by increase the upload and download batch generations.
My question is how can I recover the data which has been lost?
Thanks
i make an application to insert data to sdf file and save it
when i colse the application and open it again i find my stored data on the sdf file well
and if i closed the application 1000 times i'll find my data ok
that's ok and that's not the problem
the problem that when i open this sdf file from sql server management studio and make a select on it i don't find any result and when i try to open the db from my application again i found it empty with no data
i realized that management studio delete's the data from my db
Any Ideas Here ???
Our SQL database log file got physically deleted. Now the database is in suspect mode. Is it possible to recover / restore the database just with the data file.
View 3 Replies View RelatedI created a new database and want to recover data from a backup this script
use master
go
restore database new
from disk='D:
ew.bak'
go
but get an error
Message 3141, Level 16, State 0, Line 1
The database to be restored was named 'ats342'. Reissue the statement using the WITH REPLACE option to overwrite the 'new' database.
Message 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Hi all
Any way to Recover truncated, deleted, or modified data . i will be appreciated for any help
Hi all, I am working with SQL Server2000 and I have done a horrible thing here.
We here have an script that delete all data from all user tables of a database, and I run it in the master DATABASE.
As we don't made backups of this database, now somethings of the database aren't working.
Here is the script:
declare @table_name sysname
declare @alter_table_statement varchar(256)
declare @delete_statement varchar(256)
-- definindo o cursor...
declare table_name_cursor cursor local fast_forward for
select
name
from
sysobjects
where
xtype = 'U'
and
name <> 'dtproperties'
-- desligando os vínculos...
open table_name_cursor
fetch next from table_name_cursor into @table_name
select @alter_table_statement = 'alter table ' + ltrim(rtrim(@table_name)) + ' nocheck constraint all'
exec(@alter_table_statement)
while @@Fetch_Status = 0
begin
fetch next from table_name_cursor into @table_name
select @alter_table_statement = 'alter table ' + ltrim(rtrim(@table_name)) + ' nocheck constraint all'
exec(@alter_table_statement)
end
close table_name_cursor
open table_name_cursor
fetch next from table_name_cursor into @table_name
select @delete_statement = 'delete from ' + ltrim(rtrim(@table_name))
exec(@delete_statement)
while @@Fetch_Status = 0
begin
fetch next from table_name_cursor into @table_name
select @delete_statement = 'delete from ' + ltrim(rtrim(@table_name))
exec(@delete_statement)
end
close table_name_cursor
open table_name_cursor
fetch next from table_name_cursor into @table_name
select @alter_table_statement = 'alter table ' + ltrim(rtrim(@table_name)) + ' check constraint all'
exec(@alter_table_statement)
while @@Fetch_Status = 0
begin
fetch next from table_name_cursor into @table_name
select @alter_table_statement = 'alter table ' + ltrim(rtrim(@table_name)) + ' check constraint all'
exec(@alter_table_statement)
end
close table_name_cursor
deallocate table_name_cursor
I have tried to restore master table with the restore function, but it doesn't work. When I try to do this I received a message informing that it can't copy the data because one file was in use. The server was in a single user mode.
Is there anyway to recover the data that I have lost?
I have deleted some data from some table. I dont have any backups and the database in simple recovery Mode. How to recover that data ...
View 15 Replies View RelatedI Somehow restored the latest database onto the test database. Can I now retrieve the lost data. If Yes , How is it possible.
Akash
Is there any way to get the deleted records from LDF or MDF file. Today by accidentally I executed one query and that dropped my table Inbox(table name only) from database. And in that table there was more 4,000 records, all these lost. So anybody can help me how to recover this table records?. Is there any way to get these?
I don't have any backup for this table.
shaji
hi,
i want to lost data automatically after 3days.
but i don't know how to use job scheduling in sql2000 and how to query to add date to datatime column automatically when the data is inserted.
Plz help me!
Cristiano writes "hi everybody.
A customer of mine has had a disk "crash" few days ago.
I wrote for him a dwh application and
of course the backup was not working...
now some "hardware guys" said that it is possible to recover most of
the files.
what I need to restore would be:
1- the sql server db
2- the sql server dts and jobs
3- the analysis service cube and dimensions
to do so is it enough for me to have:
1- the .mdf and .ldf files
2- the master.mdl /.ldf file
3- the .odb file and .dim* and .role .map ... files
right?
is it enough to recover everything?
if it is so, what would be the right processes to recover everything? "
Urgesnt..data lost when run the script.i generate a script a data base then i run it on query analizer in same data base .But problem is data base and all design view is safe but all data is lose.how can recover it.thanks.
View 2 Replies View RelatedHello All,
Thanks in advance for your help.
I am wondering if there is a correlation between the size of a database and the amount of RAM required in the server. Here's what's going on:
NT4.0 SP 6a, SQL 7.0
2-800 MHz Pentium III Processors
512 MB RAM
Swap Files: two, divided evenly between two partitions, min 512 per partition (dynamic)
3- 9.2 GB Drives, RAID 5
SQL Database size: 2.5 GB
The SQL administrators have a scheduled job set to dump the database every four hours, so they have 6 of these dump files per day. Seagate Backup Exec v 6.? backs up those files every evening. Of course, this is a mission-critical application.
As the NT/Hardware administrator, I was tasked to flash upgrade all the hardware that could be flashed. That happened about three weeks ago. Ever since I flashed it, getting the data dumps has been an inconsistent process. Sometimes it works, sometimes it errors out. The error message is " Lost Delayed - Write Data: The system was attempting to transfer file data from buffers to (path). The write operation failed, and only some to the data may have been written to the file."
On and off during the day, you can't even copy a small file on the server without receiving the same message.
Before I flashed the server, it was blue-screening and needing to be rebooted about once every two weeks. Since I flashed it, the server hasn't been rebooted, because it hasn't blue-screened.
The database dumps are about 2 GB. We were thinking that the way the dump process worked was that a snapshot of the data was put into memory before it was written to disk. We thought since the dump size was larger than Physical Memory + Virtual Memory, that that could be causing the error.
What do you guys think?
1. Is dumping the database first the preferred way to get a backup, or should a backup directly to tape be scheduled instead?
2. Do we have enough RAM for the database?
3. Are there special settings we should set for the RAID controller card to maximize throughput for SQL?
Thanks again. I am definitely not a SQL DBA and any information you can provide would be really helpful.