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
When I run the sql server 2000 setup, it just hangs. What do I do?
What is the language structure to add a record to a table?
What is replace and stuff function in sql server?
Why the trigger fires multiple times in single login?
Explain what is the use of custom fields in report?
Explain the different types of backups available in sql server? : sql server database administration
What is difference between table aliases and column aliases? Do they affect performance?
Can you force a query to use a specific index?
What is nolock hint in sql server 2008
In which format does an image save in SQL Server database ?
What is normalization 1nf 2nf 3nf?
What command would you use to add a column to a table in sql server?
What is difference between line feed ( ) and carriage return ( )?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
what are triggers? : Sql server database administration