What are the different types of backup avaible in SQL SErver
Answer Posted / pavan
full
differential
transaction
taillog
copy_only
mirror
files and file group
partial
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
what is datawarehouse?
You want to implement the one-to-one relationship while designing tables. How would you do it?
Explain transaction server consistency?
Explain what are the events recorded in a transaction log?
Explain “@@rowcount” and “@@error” in sql server?
How to get nth highest salary from employee table.
How to return the top 5 rows from a select query in ms sql server?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
How adventureworkslt tables are related?
How to find the list of fixed hard drive and free space on server?
explain extended properties
Define full outer join?
What are the different types of backups avaialabe in sql server 2005?
What are the different SQL Server Versions you have worked on?
How can you manage sql azure security?