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
What is auditing in sql server?
Can you please explain the difference between primary keys and foreign keys?
how will add additional conditions in sql?
what is an index? : Sql server database administration
What is tablix?
Explain linked server in sql?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
What are the new features of sql server 2012 reporting service?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
Why do we partition data?
what stored procedure can you use to display the current processes? : Sql server administration
How do you trace the traffic hitting a sql server?
What are the results of running this script?
write an SQL query to list the employees who joined in the month of January?
what is package and it uses and how can u call a package