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 are the differences between lost updates and uncommitted dependencies?
What are user defined functions in ms sql server?
How do I schedule a sql server profiler trace?
How to delete database objects with "drop" statements in ms sql server?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
what is a check constraint?
What are the differences between user defined functions and stored procedures?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
What is the difference between dropping a database and taking a database offline?
Can we add a cpu to sql server?
What is the difference between count () and rowcount ()?
What are the different methods available under sqlcommand class to access the data?
How do I create a trace in sql server?
What are the different types of columns types constraints in the sql server?
What is the order in which the sql query is executed?