To who can help... I have problems, I had my harddisk (raid 5) damaged, and I am trying to recover a backup that was " suspect " got to...

How It Works

Get an answer in three easy steps. Here's how it works...

Ask Your Question

1. Ask Your Question

Enter your programming question at the top of this page and click Get An Answer.

Pick Your Priority

2. Pick Your Priority

Tell us how quickly you want your programming question answered.

Get An Answer

3. Get An Answer

Connect with your programmer via online chat or telephone call.

Answer

Customer
To who can help... I have problems, I had my harddisk (raid 5) damaged, and I am trying to recover a backup that was " suspect " got to place in the air but, I have problems in some tables where get to execute a "select count" but I don't visualize the data, I already tried several dbcc (reindex,check...) I found in the net an application mssqlrecovery but it has limitation of registrations and it generated me the * gigantic .sql of 1.4 gb, well if somebody knows how I do for at least to get to visualize the data can copy and to glue and then to use the dts to matter in a new base. I thank any help.
Posted
jazerr
Programmer
Try making an in memory temp table, selecting the data into it, and then back out. DECLARE @tmp TABLE (col1 int, col2, varchar(256)) INSERT INTO @tmp SELECT * FROM badTable SELECT * FROM @tmp I had a similar prob where the data in the table wouldn't vis, and I tried doing it in memory, and all was well... let me know how it goes.
Posted

quoteTestimonialsquote

About ExpertHelp

ExpertHelp is changing the way you connect with service professionals.

Whether you have a quick question while preparing your taxes, troubleshooting a computer problem, or need to hire an attorney, ExpertHelp is the most convenient and affordable way to connect with the right service professional to get the job done.

ExpertHelp has been in business since 2011, is an A+ Rated Better Business Bureau accredited member, and offers a 100% satisfaction guarantee on every question you ask!

More Programming Questions...

Ask Your Programming Question & Get An Answer Now!