a sql server database always contains two file.*.ldf *.mdf
When *.ldf was deleted the database may suspend.we can repair such database through about 20 steps.
if you want repair your database .please contact me with email:cn9526@163.net or msn/email :paulyang8848@hotmail.com
you can also see our homepage http://www.haou.net/sqlother/
the service price is begin at 200 US DOLLOR.
Hi there.
I have a corrupt .sdf database sat on a SD Card but i am unable to find a way to repair it.
So far I have tried a few different methods, most of which just tell me what i already know i.e. "the database is corrupt and needs repairing!!"
I am unable to open the file in SSMS object browser (see above message) which means i cant run repair / shrink utilites.
I am also unable to add the database to a vs2005 project (again see above message) meaning again i can't run any repair utilities.
I have also tried using the compact / Repair utility in Query analyser 3.0 on my Windows Mobile 5.0 PDA but once again i am greeted with an "error reading file - Run the Repair Utility" Message.
Lastly i've tried using the SQLCEengine.repair method and, depending on whether i do it on the PDA or on a desktop pc it throws the exceptions "Error occurred reading database file - run the repair utility"(PDA) or "invalid database type" (PC)
Can anyone shed any light as to whether there is another (easier???) way of doing this or if i just have to face it that this file is lost?
Thanks
ps. the code i used for the .repair is as below:
Dim conn As SqlCeEngine
Dim strdb As String
strdb = "SD CardPathnameDatabase.sdf"
conn = New SqlCeEngine(String.Format("Data Source={0}", strdb))
If conn.Verify = False Then
conn.Repair(Nothing, RepairOption.RecoverCorruptedRows)
MsgBox("Successfully Repaired")
End If
Hi,
Some of the data files on our database got corrupted. Is there any tool to get just the data out of the data files and dump somewhere. We can manually rebuild the database using the schema scripts and loading the data. Appreciate any help. Any suggestions are welcome too.
Thanks.
I got help from Dan Guzman on how to set single-user-mode.Thank you very much.After seting single-user-mode, I run DBCC CHECKDB('MYDATABASE',REPAIR_REBUILD)Tehre are error messages.How can I repair torn page problem?Thanks.*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies View RelatedHi,Is it possible to somehow set a SQL Server DTS job to automaticallydisable itself, when it encounters a fail, so that future scheduledoccurrences don't happen until the problem has been fixed?I've hunted about for this on the web, but drawn a blank unfortunately!Many thanks if anyone can help at all.
View 2 Replies View RelatedI 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 ???
Is there any way to suspend a trigger execution after a commit trans?
View 6 Replies View Related¡¡¡¡¡¤ ¶ªÊ§*.ldfÎļþµÄMS SQL SERVERÊý¾Ý¿â»Ö¸´ÒµÎñ
¡¡¡¡Èç¹ûMS SQL SERVERÊý¾Ý¿â¶ªÊ§ÁË*.ldfÎļþ£¬Ö»ÓÐÒ»¸ö*.MDFÎļþ£¬½« ÊǷdz£Î£ÏÕµÄÊÂÇ飬Êý¾Ý¿âºÜ¿ÉÄܽ«ÎÞ·¨Ôٴδò¿ª£¬¶øÇÒ »áÏÔʾ¡°suspend¡±»òÕß¡°ÖÃÒÉ¡±×ÖÑù¡£»Ö¸´¸ÃÀàÊý¾ÝÊÇÊ ®·Ö¸´ÔÓµÄÊÂÇ飬ÐèÒª20¼¸¸ö²½Öè¡£
¡¡¡¡ÔÚ´ËÌáÐÑSQL SERVERÓû§£¬Èç¹ûÄúµÄÓ²ÅÌ×ã¹»´ó£¬Ç벻ҪʹÓÃÊý¾Ý¿âѹ ËõºÍÕûÀíµÄÃüÁîÀ´¶ÔSQL SERVERÊý¾Ý¿â½øÐвÙ×÷£¬·ñÔòºÜ²»ÈÝÒ×ÇÀ¾È¡£
Çë¿´http://www.haou.net/sqlother/
Hi there, i have still some Problems with the SQL Server Express.
Sometimes (not always) it seems that the SQL Server Express "sleeps"
I write through my application every 60 seconds some values in a table , but somethimes it seems that the server is not reachable and i cannot wrote the data. but the phanomen are only happens for a record , the next time it works fine. (i check always for a open connection) if i cannot write the data , it seems that the connection is "away" and i reopen it. after that everything works
i have also try with the sql server auto close to false but with no success.
what could that be ?
greetings
Hi
Im new to the world of sql server
I gonna write some t-sql stored procedures,and need to log error information in a database table, but don't want that log entry to be a part of the logical transaction.
So basically i want to
suspend the main transaction, perform SQL operations , commit or rollback those operations, and resume the main transaction.
Any ideas ?
Cheers
I am wondering if there is any statement which I can write at the start of my script that causes some referencial integrity problem so that foriegn keys dont regulate my script and foriegn keys allow it to run.
Any help will be greatly appreciated.
Fahad
I 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
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
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!
Hello,
A call to a stored procedure via the SQLCommand.ExecuteReader() is made. When the stored procedure goes into suspend state the ExecuteReader() call returns. The stored procedure is not yet finished, after the suspend state it goes into the runnable state and performs some calculations.
Is it possible to set a configuration that the ExecuteReader doesn't return when the stored procedure goes into suspend, or must an other method be used?
Tx
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.
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 RelatedI have a website that is used to enter dates from a calendar. For example, user A might go to the website and select 20 different days in January. When user A clicks on the Save button the dates are written to the database with an INSERT command. This works fine. However, when user B then goes through the same procedure, say selecting 5 dates that are in the set selected by user A, those dates are properly saved in the database but the rows containing user A's same 5 dates disappear. I suspect this is something simple but I'm new and ignorant. Please help.
View 4 Replies View Related
I have Excel file with data and I need load these data to database. One of the colume consit following data:
1
2
3
4
test5
6
7
8
9
but when I created connection (Excel Source) and click Preview... in Excel Source Editor, I got following data:
1
2
3
4
NULL
6
7
8
9
Why? How can I get all data as string?
I am migrating from 2000 to 2005 and in the process of rewriting DTS to SSIS. So far so good.
I have an import of a flat file that I need to reproduce that works fine in DTS but throws SSIS.
The file contains details of products, and has a Long Description field that may contain lots of different chars - CR & LF amongst them. It's source and destination columns are Text type.
The file is tab delimited, text delimited with double quotes, with row delimiters of CRLF and column names on row 1.
The error SSIS throws is "The column delimiter for column "LongDescription" was not found"
I imagine (perhaps wrongly) that this is because of the extra CRLFs but it worked fine in DTS. It also previews fine, and lets me define the column properties OK in SSIS package designer.
Any help greatly appreciated. I am trying to avoid the obvious thing of replacing those chars in that field at this point as currently the export is shared between a live production server, and my test 2005 rig.
Thanks v much.
Chris.
I know that anything in a CDATA section will be ignored by an XML parser. Does that hold true for the SSIS XML Source?
I am trying to import a large quantity of movie information and all of the reviews, synopsis, etc are contained in CDATA. example:
<synopsis size="100"><![CDATA[Four vignettes feature thugs in a pool hall, a tormented ex-con, a cop and a gangster.]]></synopsis>
Sounds like a good one, no?
The record gets inserted into the database however it contains a NULL in the field for the synopsis text. I would imagine that the reason for this would fall at the feet of CDATA's nature and that SSIS is ignoring it.
Any thoughts would be appreciated. Thanks.
I need help!
I have Outlook 2007 w/BCM running on XP Pro workstation connecting to a SBS 2003 R2 hosting my SQL 2005 database. I have two problems: First I can get the BCM to connect to the remote data but periodically the connection is lost and many times it requires a reboot to reconnect. Secondly related to teh first, I can never get MS Accounting 2007 to connect to the same server and database from my client.
I have already set up the server to use port 5356 via TCP amd added a hole through my client windows firewall for the same port. Both client and server are set to share files and printers.
Any suggestions?
Hello,
Data is being trnasferred from an Oracle view to a SQL Server 2005 table.
Decimals can be previewed in the from the "SQL Command Text Window" but the columns in the target table which are defined as float shows the data being rounded to zero decimal places.
For the Data Source the always use default code page is selected.
Is there a way to retain the decimals?
Thank you,
Rod
I am using visual basic 2008
I am making a program, I used sql server compact edition (sdf) (i think it is no more only for mobile device, I am working for desktop application)which i created with the same visual basic. i update data by using table adapters,
when I close the program and build again, the data previosly updated are deleted, and I get empty database?? why is that. do i need to set some copy to.........properties. i have used copy if new.
Recently we observed a problem. We are running stored procedure through our c# code. Three machines access the server and update or insert in the required tables in the server. If there is no data in the server, on installing first time our application usually our database is clean. then stored procedure works fine, it takes around 10 to 15 sec to execute. Next time if execute the time goes up to minutes like 15 mins. Next time it goes for hours around 4 hrs. Even to update 4 or 5 records it takes time. Initially we thought it was because of the size of the data and we tried to re tune on indexes, it did not solve. But now what we observe is even with less number of records in server also it wouldn't come of the execution for hours.
Now are executing the just the SP in the SQL manager studio to see the time. That one also is executing for hours. when looked at the activity monitor the process goes to suspend state with wait type ASYNC_NETWORK_IO.
When we comment one of the query is working fine.
Is this something to do with the query I am not sure. If that is the case it should not work every time.
The query makes any sence or is there any way to write it in better way
'UPDATE [server].[dbo].[DocumentMetadata] SET DocumentInfoID = b.DocumentInfoID, [Name] = b.[Name], MetadataType = b.MetadataType,
[Value] = b.[Value], ValueType = b.ValueType
FROM [server].[dbo].[DocumentMetadata] a WITH (UPDLOCK)
INNER JOIN (SELECT c.DocumentInfoID, c.[Name], c.MetadataType, c.[Value], c.ValueType
FROM MACHINENAME.[Client].[dbo].[DocumentMetadata] c
INNER JOIN MACHINENAME.[Client].dbo.DocumentInfo DINF ON c.DocumentInfoID = DINF.DocumentInfoID
INNER JOIN MACHINENAME.[Client].dbo.Path d on DINF.NativeFileID = d.PathID
INNER JOIN MACHINENAME.[Client].dbo.ActiveDataSource ADS ON d.DataSourceID = ADS.DataSourceID
WHERE ADS.ProjectID = ''' + @ProjID + ''') b
ON a.DocumentInfoID = b.DocumentInfoID AND a.[Name] = b.[Name]'
'INSERT INTO [server].[dbo].[DocumentMetadata]
(DocumentInfoID, [Name], MetadataType, [Value], ValueType)
SELECT c.DocumentInfoID, c.[Name], c.MetadataType, c.[Value], c.ValueType
FROM MACHINENAME.[Client].[dbo].[DocumentMetadata] c
INNER JOIN MACHINENAME.[Client].dbo.DocumentInfo DINF ON c.DocumentInfoID = DINF.DocumentInfoID
INNER JOIN MACHINENAME.[Client].dbo.Path d on DINF.NativeFileID = d.PathID
INNER JOIN MYCLI.[Client].dbo.ActiveDataSource ADS ON d.DataSourceID = ADS.DataSourceID
WHERE ADS.ProjectID = ''' + @ProjID + '''
AND Ltrim(rtrim(c.DocumentInfoID))+ ltrim(rtrim(c.[Name])) NOT IN
(SELECT Ltrim(rtrim(DocumentInfoID))+ ltrim(rtrim([Name])) FROM [server].[dbo].[DocumentMetadata])'
We have been fighting it out for so many days.
Can anybody help
Thanks
knvdssr
We currently use a split-mirror backup strategy for our Sybase database, which has a "quiesce database" command to suspend all transactions. By quiescing the database before splitting the mirror, we suspend all transactions to ensure we get a stable backup of the environment. It works very well for us and I'm trying to understand how we could implement this with our SQL Server 2005 DB.
(I'm aware of SQL Server mirroring and that there are other ways of possibly backing up the DB. In this post however, I'm only interested in how I would make the split-mirror strategy work if I wanted to pursue it. I'm trying to avoid paying for software that uses the VDI as it's quite costly.)
Can someone help me with how I would accomplish a split-mirror backup strategy in SQL Server 2005 (without using a vendor's software that uses the VDI)? I have to imagine there's something similar to the "quiesce database" command in SQL Server...
I appreciate the help!