I developed one Visual Studio .Net(C#) Project.After Publishing I couldn’t access Database(.mdf file). can yuo tell how to backup?
Where to start … On 6/2 we lost a major system that we found relies on a database that hasn’t been backed up since 5/7. We lost 3 of 4 HDD in a RAID5 array. We sent the drives to a recovery firm and they have recovered all of the data. However, the timestamp on [...]
i have a new mdf and ldf file created in sql server 2000.how could i attach these to sql server 2005 enterprise edition?i tried it by right click the database and select attach.but it shows an error when click the add button in database dialogue box.
I recently restored our SQL Server database from a backup, but unfortunately I used a Wednesday backup instead of Thursday, and it is now Friday. Is there a way to merge MDF files, to join all the data together because, as of now, we are missing Thursday’s data.
I have MDF and LDF files with different modified dates. How could I attach these to SQL Server 2000
I lost a LDF file for SQL server 2000 — but I have the MDF. How can I recover my data?
I am receiving the error, “cannot find log file.” I detach the database and I am unable to reattach it because of the error. I created a new database and copied the MDF. When I restarted the SQL Server, I am told the database is suspect. What can I do to fix this error?
I’ve heard it recommended to place the tempdb on its on own drive. Regarding the tempdb log file specifically, should it be on a different disk than the mdf or ndf files of the tempdb?
How can i merge the MDF and NDF files of SQL Server databases?
I have MDF and LDF files with different modified dates. How could I attach these to SQL Server 2005?
How can I restore a SQL database with an .mdf file?
Hi I have job which creates databases based on month in analysis services which contains cubes in the databases. I need to create a job to move the database ldf and mdf files of the previous months removing the database from the server if the month changes to next month. The database files should be [...]
Hi, We get the following error while trying to create a new db from a dump which contains the MDF and LDF files. Appreciate if anyone could let me know on what could be the reason for this error. The operating system returned error 38(Reached the end of the file.) to SQL Server during a [...]
My database saves as MDF. I want to know what are the steps to restore or create a new database using a MDF file? I tired to restore as usual but it shows an error. Please help.





