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
In what three ways is the return statement used in a stored procedure?
What are a database and a data warehouse?
Describe in brief databases and sql server databases architecture.
Can sql server be linked with other servers like oracle?
How do I view a trc file?
How to access the deleted record of an event?
How can we migrate from SQL server to SQL Azure?
Explain how would you store your query in an SSRS report or a Database server?
What are constraints in microsoft sql server?
What are the differences between union, intersect, and minus operators?
How to move database physical files in ms sql server?
What is an indexing strategy?
What are the difference between clustered and a non-clustered index?
To which devices can a backup be created and where should these devices be located? : sql server management studio
How can a database be repaired?