What are the different types of backup avaible in SQL SErver
Answer Posted / amit kumar
Full - backups entire database
Differential - backups all changes since last full backup
Transaction Log - backups transaction log for all changes
since last transaction log backup
File - allows you to backup one data file
Filegroup - allows you to backup an entire filegroup
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How do I shrink an ldf file?
Define full outer join?
Explain different types of locks in sql server.
How do I uninstall sql server 2014?
Can a database be shrunk with users active?
How to loop through result set objects using mssql_fetch_array()?
What are the advantages of policy management?
If we delete pack Spec what will be the status of pack Body ?
How to find out the list schema name and table name for the database?
What does it mean to be in union?
What is sql collation?
Define inner join? Explain with an example?
How do I setup a sql server database?
What is a join in sql? What are the types of joins?
How to connect to SQL Azure Database by using sqlcmd?