Bagath (10/25/2007)

---

Hi all,

I have taken more than one database backups and i have an idea that we can verify single backup using "restore verifyonly from disk=' '"...

Ya ofcourse,I did not implement the things directly on main database.

Just got that doubt and implemented in sample database which was created by me for practice purpose on test server.

Thank...

Hey finally i have got the answer...

http://msdn2.microsoft.com/en-US/library/aa196704(sql.80).aspx#

Really this forum is very helpful to me to learn many things.....

Awesome........

Thanks a lot...

Could you explain in detail....?

Ya sure..

I will try to compare the data and also will try to get the info from the customers,what they were done?

I think this is a big task for me....Pchhhhhhhhhhh...

There are more tables invovled during the operations....

Even do not know which module(s) they had used.....

Thanks,

No tools available here.....

any other way through the backups....?

Thanks,

Bagath

Thanks allot for the info....

Why not sir....

Following is the script for to create a table with cursor data....

 

ALTER PROCEDURE Reports1  @START_DATE DATETIME,@END_DATE DATETIME

AS

DECLARE @T_DBANAME VARCHAR(40)

DECLARE @T_TEAM INT

DECLARE @CreateTab VARCHAR(2000)

SET @CreateTab='CREATE TABLE TabDbaData('

--CURSOR TO FETCH ALL...

Thank you very much for your valuable suggestion.

I have tried as above and succeeded

Thanks once...

Thanks to one and all for your valuable suggestions......

 

Bagath

Thanks for your valuable suggestions.....

I will try to implement....

Thanks once again...:-)

Bagath.......

Matsmura,

   Can you explain me clearly....?

 

Thanks,

Hey David,

 

        Excellent solution.The Query is working fine with my criteria.

Let me say,Thank you very much to all of you for your support.

Once again thanks to all..................:-)

 

--Bagath.

Jeff,

        The query is not working.It is not showing null if there is no backup.

 Thanks,

Bagath