Can you help with the following answer below. I need screen shot in word. This a query using adventure works. I can also produce the steps to complete the task, my visual studio is not connection to sql. PLEASE LET ME KNOW IF YOU CAN HELP ON THIS.
1. Take the command that you made to reorganize your Production.TransactionHistory table, and schedule it to run as a weekend job Sunday mornings at 2AM.
2. Perform a full backup of the AdventureWorks database. Save the backup to C:MyBackup.bak (or alter slightly if you don't have enough disk space on that volume).
3. Restore the backup you created in Exercise 2 to a new database name - NewAdventures.