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 what is de-normalization and what are some of the examples of it?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What is standby servers? Explain types of standby servers.
Explain relational data?
Why should one not prefix user stored procedures with ‘sp_’?
Explain what you mean by 3 tier architecture.
What structure can you implement for the database to speed up table reads?
When I run the sql server 2000 setup, it just hangs. What do I do?
Explain what are the events recorded in a transaction log?
What is the difference between varchar and varchar(max) datatypes?
What is a data source or ds? : sql server analysis services, ssas
Explain the Ways to improve the performance of a sql azure database?
Can you move the resources after pausing the node? : sql server database administration
What are the drawbacks of reporting in ssrs?
what is a join? : Sql server database administration