0

I'm using microsoft sql-server 2012 for my application. I use "create and restore" backup commands but when I restore backup, all objects will be restored such as stored procedures. How can I create backup and restore it only for specific objects of my database?

mehdi lotfi
  • 11,194
  • 18
  • 82
  • 128
Babak.Abad
  • 2,839
  • 10
  • 40
  • 74

1 Answers1

0

You can't. You could restore the backup with a different database name, then copy the required objects across to the live DB.

A better approach would be to keep you progammables in a change control system. Then you would be able to retrieve any version of any object whenever you need.

Michael Green
  • 1,397
  • 1
  • 17
  • 25