Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 BACKUP

Author  Topic 

antony_dba
Starting Member

26 Posts

Posted - 2010-11-27 : 04:32:23
Using differential backup we can able to restore the database

kris

Kristen
Test

22859 Posts

Posted - 2010-11-27 : 06:42:57
You need the FULL backup made before the DIFF backup. If you do not have that you cannot restore from the DIFF. You cannot use any other FULL backup, it must be the Full Backup preceding the DIFF.
Go to Top of Page

antony_dba
Starting Member

26 Posts

Posted - 2010-11-29 : 02:07:48
TABLE1

Suggest the query for the result table...

a b c
- - -
1 3 23
1 4 32
2 5 32

i need the result table as

a b c
- - -
1 3 23
- 4 32
2 5 -


kris
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-11-29 : 03:47:45
Please ask unrelated questions in a new thread.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -