adspace
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
How can I check that whether automatic statistic update is enabled or not?
What is standby servers? Explain types of standby servers.
What is in place upgrade in sql server?
How can you append an identity column to a temporary table?
Disadvantages of the indexes?
Why we use the openxml clause?
What is the difference between for xml raw and for xml auto?
Why should you use or avoid select * statements?
Can we do dml on views?
How to connect php with different port numbers?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
How to convert character strings into numeric values?
What kind of problems occurs if we do not implement proper locking strategy?
What is the difference between upgrade and migration in sql server?
What is sql or structured query language?