0

I was studying SQL Server and I got a question about about creating queries for backing up database.

I knew that SQL Server 2008 has function to create a .bak file.

However, I am not sure if I can generate the queries for whole database.

In SQL Server 2008, do they have function to generate the queries for backing up whole database ?

thanks

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Dc Redwing
  • 1,681
  • 11
  • 32
  • 42

1 Answers1

2

You can generate the script yourself just setup a backup like normal but instead of clicking the normal button to start in the top left corner there is a script option enter image description here

See the backup command for more advanced options

Daniel Powell
  • 8,143
  • 11
  • 61
  • 108