clone

Question

hi all,

what is the database clone in ms sql server db...?

Answer 1

There in nothing called as cloning in sql server , Here it comes as High availability

I think you're asking about

Database Mirroring -:http://msdn2.microsoft.com/en-us/library/ms177412.aspx

Log shipping  : http://msdn.microsoft.com/en-us/library/bb895393(v=sql.105).aspx

---

Thanks Saurabh Sinha

http://saurabhsinhainblogs.blogspot.in/

Please click the Mark as answer button and vote as helpful if this reply solves your problem

Answer 2

As Suarabh said, there is nothing called cloning in SQL Server.

However, you can use the below if you are looking for restoring the db to the previous state.

http://blogs.technet.com/b/sql_server_isv/archive/2011/04/22/fundamentals-cloning-a-production-database-to-a-test-server.aspx

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 3

Oracle Database has concept of DB cloning not sql server..Also Windows server can be cloned.

---

Soldier..Sir we are surrounded from all sides by enemy.. Major: Good, we can attack in any direction Thats attitude.. Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

Answer 4

Actual the term clone means to make a duplicate copy.

1) The easiest way is to clone is take the backup of the database and restore it on some where.

2) Some times people will seek the database structural clone with means the duplicate database which doesn't have any data. To implement this please use generate script option and make sure "Script Data" option should be false and some spl cases people will use "Script Statistics" with "Script Statistics with histograms"

The 2nd which i was used to send the structural clone to MS

3) As per your requirement you can implement any of the high-availability feature for your business needs...

Thanks,

---

Thanks, Satish Kumar. Please mark as this post as answered if my anser helps you to resolves your issue :)

Answer 5

@Satish Kumar,

I had one collegue whose name is Satish Kumar in Foxconn some years ago, I do not know whether it is you...

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 6

@Satish Kumar,

I had one collegue whose name is Satish Kumar in Foxconn some years ago, I do not know whether it is you...

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

@Wison-Ho:

I m not that Satish Kumar.. for whom you are looking for :)

---

Thanks, Satish Kumar. Please mark as this post as answered if my anser helps you to resolves your issue :)

Answer 7

Can you explain what you meant by clone? There is a method which is termed as "clone" and the method is explained in this article.This method is used primarily by microsoft technical support for resolving performance issues of customers. More in this link

http://sqlmag.com/sql-server-2005/efficiently-clone-databases

HTH

---

Regards, Ashwin Menon My Blog - http:\\sqllearnings.com