Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What are the differences between lost updates and uncommitted dependencies?

1067


What are user defined functions in ms sql server?

989


How do I schedule a sql server profiler trace?

968


How to delete database objects with "drop" statements in ms sql server?

1078


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?

1002


what is a check constraint?

1091


What are the differences between user defined functions and stored procedures?

1059


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?

1051


What is the difference between dropping a database and taking a database offline?

1164


Can we add a cpu to sql server?

1003


What is the difference between count () and rowcount ()?

1016


What are the different methods available under sqlcommand class to access the data?

1113


How do I create a trace in sql server?

1026


What are the different types of columns types constraints in the sql server?

1076


What is the order in which the sql query is executed?

934