Click here to Skip to main content
15,357,293 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello,

How to create sql server database backup and restore sql server database only current modification of database?

I want take backup only current modification database and restore our old database.

and should be up end or override my old database in sql server and how to write query for this.

Please help me.

Thanks in Advance

Ankit Agarwal
Software Engineer
Posted
Updated 8-Nov-13 0:00am
v2
Comments
kumar9avinash 8-Nov-13 6:08am
   
u can take backup of sql server through wizard, and then copy the back up file which is inside the sql server folder
[no name] 8-Nov-13 6:13am
   
No Buddy, I have already know but I don't know that How Restore the latest differential backup. using query in sql server?
Amitava Bag (Kolkata) 8-Nov-13 7:13am
   
Please read http://sqlmag.com/blog/does-sql-server-have-incremental-data-backups. I think the differential backup will autometically when you take backup (or schedule) in same file (.BAK) continuously. At the time of restoration it shows every set, and ask the set to load. I assume it, not tried. Ineterested to see the result.
Amitava Bag (Kolkata) 8-Nov-13 9:30am
   
There is a option to take the backup in deferential mode at the time of backup. You have to take backup on an existing backup file.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900