Interested to Buy Any Domain ? << Click Here >> for more details...
Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
- 1 Answers
- 5350 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
o A full database backup is a full copy of the database.
o A transaction log backup copies only the transaction log.
o A differential backup copies only the database pages
modified after the last full database backup.
o A file or filegroup restore allows the recovery of just
the portion of a database that was on the failed disk.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What authentication modes does sql server support? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
What is transparent data encryption? : sql server DBA
how can you communicate with operating system files from oracle?
How do you trace the traffic hitting a sql server? : sql server DBA
Why would you call update statistics? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
what are the benefits of flashback feature?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How to start SQL Server in minimal configuration mode?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What would you do with an "in-doubt" distributed transaction?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
