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

Tell me what is de-normalization and what are some of the examples of it?

1098


you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1295


What is standby servers? Explain types of standby servers.

1049


Explain relational data?

963


Why should one not prefix user stored procedures with ‘sp_’?

1095


Explain what you mean by 3 tier architecture.

1122


What structure can you implement for the database to speed up table reads?

1231


When I run the sql server 2000 setup, it just hangs. What do I do?

1123


Explain what are the events recorded in a transaction log?

1048


What is the difference between varchar and varchar(max) datatypes?

1129


What is a data source or ds? : sql server analysis services, ssas

1049


Explain the Ways to improve the performance of a sql azure database?

84


Can you move the resources after pausing the node? : sql server database administration

1157


What are the drawbacks of reporting in ssrs?

159


what is a join? : Sql server database administration

1319