What are the different ways of moving data/databases
between servers and databases in SQL Server?
Answer Posted / venkat reddy.ravu
You can use simple backup/restore methods,attach and
detach,script based data loading,bulk DDL state ments like
select...into,insert..into,Implimenting data availability
methods like replication,log-shipping,mirroring,clusturing
etc..
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
tell me the disaster recovery plan
How many types of schemas are there?
Where cross join is used?
How can sql injection be stopped? : sql server security
How to find table changes in sql server?
What stored by the tempdb ? : sql server database administration
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is #table in sql server?
What is 'Join' and explain its various types.
What is the purpose of sql profiler in sql server?
What is left outer join in sql server joins?
How many instances per computer are there in sql server 2000?
Can you explain what are commit and rollback in sql?
what is the difference between a primary key and a unique key? : Sql server database administration
What command would you use to add a column to a table in sql server?