> > >

Transact-SQL (T-SQL) MCQs

You need to create a simple database backup in the server's Z:\Backups directory. Which query should you use?

BACKUP MyDatabase TO LOCATION = 'Z:\Backups\MyDatabase.bak';

CREATE BACKUP (DATABASE = 'MyDatabase' TO DISK = 'Z:\Backups\MyDatabase. bak');

BACKUP DATABASE MyDatabase ON 'Z:\Backups\MyDatabase.bak';

BACKUP DATABASE MyDatabase TO DISK = 'z:\Backups\MyDatabase.bak';

Answer

Correct Answer: BACKUP DATABASE MyDatabase TO DISK = 'z:\Backups\MyDatabase.bak';

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Transact-SQL (T-SQL) Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it

More Transact-SQL (T-SQL) MCQ Questions

Transact-SQL (T-SQL) Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it