Interview Questions
1. What all operations are prohibited when the database backups are running?
Operations that cannot run during a database backup or transaction log backup include the following:
• File-management operations such as the ALTER DATABASE statement with either the ADD FILE or REMOVE FILE options.
• Shrink database or shrink file operations. This includes auto-shrink operations.
• If you try to create or delete a database file while a backup operation is in progress, the create or delete operation fails.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment