What are the different ways of moving data or databases
between servers and databases in SQL Server?
Answer Posted / santo
export/import...attach/detach...DTS....backup/restore!
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Where do you find the default index fill factor and how to change it? : sql server DBA
What is the importance of a recovery model? : sql server DBA
What is the default fill factor value? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
what is the use of recording information about current session?
how can you find out if a table can be redefined?
What are the commands used in dcl? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
what do you understand by flashback feature of oracle?
what are the benefits of flashback feature?
Why would you call update statistics? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA