What is the difference between online backup & offline backup?
Answer Posted / kittu_chintu2005
online backup: 1) inconsistent backup 2) database must be in archive log mode 3) database should be in upon running
offline backup: 1) consistent backup 2)database may be or may not be in archive log mode 3)database should in shut down state
Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What is a correlated sub-query? : sql server DBA
what is grd?
What is dcl? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
what are the differences of where and if in SAS?
Explain materialized views and how they are used.
Why would you use sql agent? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
how can you find out if a table can be redefined?
when does an alert gets signaled?
How can you control the amount of free space in your index pages? : sql server DBA