Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DUPLICATE db

Author  Topic 

JERICHO
Starting Member

18 Posts
Posted - 2002-10-08 : 22:26:28
Hey guys,

i got a life DB from this life server which i do not want to use during my developments for new ideas, if there anyway i can duplicate the whole DB including the tables, procedures, i mean simply everything within the DB to another inactive server.

Thanks

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts
Posted - 2002-10-08 : 23:00:35
Yes backup the database and restore it on the development server.

In SQLSVR 2000

In Enterprise Manager:

Backup
On Production Server
Right Click Databases
Select all task -> backup database
Select Database
Select Complete
Add the file to backup up to
Choose Overwrite existing media
Click Ok

Restore:
On the development server
Right Click Databases
Select All Task -> Restore Database
Give Restore Name in Restore as database
Select From Device
Select Disk And File that you backed up on the production server
Select Complete

Under the options tab
Check Force Restore
Select Leave Database Operational
Click Ok

Or take a look at Books Online. Search On Backup and Restore for T-SQL commands which you can run from the Query Analyzer.





Edited by - ValterBorges on 10/08/2002 23:01:14
Go to Top of Page

JERICHO
Starting Member

18 Posts
Posted - 2002-10-08 : 23:21:08
ok thanks but will it affect my life database i cannot afford to lose anything datas there
Go to Top of Page

rihardh
Constraint Violating Yak Guru

307 Posts
Posted - 2002-10-09 : 02:34:40
Oh man,... another kamikaze DBA...
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts
Posted - 2002-10-09 : 02:54:25
RichardH

The kamikaze thing is getting VERY boring.

This site is here to help people with questions like these. If you don't feel like helping, please keep quiet.

Damian
Go to Top of Page

Andraax
Aged Yak Warrior

790 Posts
Posted - 2002-10-09 : 03:45:39
RihardH, I'm sure you have been a newbie once too. Also, I'm sure you don't know everything. So please help instead of being so childish.
Go to Top of Page

rihardh
Constraint Violating Yak Guru

307 Posts
Posted - 2002-10-09 : 04:34:47
I appreciate any comment on my replies, but, there is some truth in my cynical approach.

Yes Andraax, I've been a newbie too, but, I knew that manipulating with data is a very serious thing and that there has to be more to that, than just inserting, updating and deleting data. So, like most (so I hope), before I even touched a live DB it took years and a lot of reading and learning.

Sure thing that my "kamikaze" replies do get boring, but so are some topics in this forum.

I'm a member of this forum for quite a while now and I've seen many good topics and articles related to MSSQL. But what I REALLY CAN'T STAND are people who jump head first into something they don't know. And to top it all, they don't seem to bother reading books or gaining experience through practice. They don't even bother reading the FAQ section of this site, not to mention BOL. It's easier for them to post every problem to a forum and let others solve it. Even if it's the simplest thing like this thread (which could easily been solved by reading a section in BOL).

We all had to invest some time, money and nerves to get where we are now. Don't get me wrong, I welcome anyone aboard the MSSQL ship, but not the turbo way.
Go to Top of Page

Andraax
Aged Yak Warrior

790 Posts
Posted - 2002-10-09 : 04:54:32
If you never touched a DB for years, it must have been a slow and painful process to learn what you know now. I prefer the method "learning by doing". Of course, I didn't "learn by doing" on production machines. You might be correct about some DBA's jumping into things to quickly, but all this guy wants is to get a test/dev platform up so that he can experiment and learn. He doesn't want to manipulate data within the production database.
Go to Top of Page

Page47
Master Smack Fu Yak Hacker

2878 Posts
Posted - 2002-10-09 : 08:15:36
Typically, 'kamikaze' refers to a Japanese pilot trained in WWII to make a suicidal crash attack.

I don't believe this poster (or others you have attached the epithet too) are intending to 'crash and burn' their systems. They simply don't know better (or at least in this case, the poster smells potential trouble and is seeking help).

"Dir sir, what is the best way for me to destroy my organizations database" - this is a 'kamikaze'...seeking to skillfully commit suicide-by-sql ...

rihardh, I think you should maybe find a different word, for you 'left-jab' posts that provides a more accurate image. What I REALLY CAN'T STAND are people who jump head first into an ill-fitting metaphor.

Or better yet, either don't post at all, or take the time to explain to the poster exactly how and why their approach to their career is inferior to yours. I find people really respond well to being told how stupid they are ...

Jay White
{0}
Go to Top of Page

nr
SQLTeam MVY

12543 Posts
Posted - 2002-10-09 : 08:35:13
Got to agree with rihardh original comment although it's not very constructive.

Comment should probably be more along the lines of
Who is taking care of the live database and do you have the access to do this and why.
All a problem for the organisation as to whether you should be allowed near a live system without supervision. But then we have no idea what the situation is (and what the

Suspect the best way to support a production system is not to ask questions here without any knowledge - might work but is very dangerous.

Suspect JERICHO wants to develop something outside the database and just needs the database to connect to (hope so) and so should really have someone available to set him up. If he's a 3rd party then shold ask for a backup of the database (if that's all that's needed) then can ask less dangerous questions like how to restore it.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

rihardh
Constraint Violating Yak Guru

307 Posts
Posted - 2002-10-09 : 08:43:08
OK guys, I give up...

You obviously didn't get the message.

Yes Andraax, it has been a slow and painfull process and it still is...
And yes, this guy fits perfectly into your definition of premature DBA's.

And Jay, if someone doesn't know how to do simplest things on a production server, then your quote fits perfectly too:

quote:

"Dir sir, what is the best way for me to destroy my organizations database" - this is a 'kamikaze'...seeking to skillfully commit suicide-by-sql ...


My only concern is, that the primary goal of a forum is knowledge exchange, NOT support for beginners who are just too lazy (or is it something else?) to pick up a book.

If you guys are still willing to support that kind of people, I don't.

So, the best of luck to you all, I'll shut up and use my time on my own problems.

From now on, I'm only reading...
Go to Top of Page

nr
SQLTeam MVY

12543 Posts
Posted - 2002-10-09 : 09:57:32
Agree with most of that apart from

>> So, the best of luck to you all, I'll shut up and use my time on my own problems.

Learn to take criticism and prove it unfounded (which of cause it should be) with extreme sarcasm. Fundamental DBA skill. One of the pleasures in life.


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

Andraax
Aged Yak Warrior

790 Posts
Posted - 2002-10-09 : 10:10:38
Rihard, the point of the whole discussion is this:

- If you find a question/discussion which you are interested in, reply
- If you find a question/discussion which is "below" you, just keep on reading and let others reply
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts
Posted - 2002-10-09 : 22:10:32
Richardh

Yes there can be a lot of stupid questions here, and yes it can get boring. But, without the volume of questions that could be answered by opening BOL the site would be a LOT quieter, and therefore wouldn't attract the more interesting discussions.

The idea is, and it does happen, that people might come and ask some silly questions, then they hang around for a bit and learn some more. Then next time a silly question comes up, the newer people open up BOL and provide an answer, learning more and more in the process.

Having been a part of the site for over two years, I have seen a number of people who started by asking simple questions, then ended up learning a lot by participating in discussions and answering questions that you obviously feel are beneath you. Now, they are very knowledgable people, and we have a few less "kamakaze" DBAs in the
world.

What I like about this forum is that people are not too intimidated to have a go at an answer. If they are wrong, so be it (We are ALL guilty of that), they get told, generally nicely, and everyone learns.


So, as I said before, if you don't have anything to add to a discussion, stay out of it, leave it to someone who might learn something by answering it.



Damian
Go to Top of Page

jhunt
Starting Member

21 Posts
Posted - 2002-10-09 : 22:33:11
For the record Kamikaze means divine wind. It refers to an incident in Japanese history where an all conquering powerful mongol army took to the boats and set sail for Japan to do some butt kicking.

Since they did not know much about the region, seasons or climate, they were caught in a typhoon which smashed their fleet and saved Japan.

In the dying stages of WWII the Japanese hoped to invite similar good fortune with the Kamikaze air fleet.

Rihardh, the mongols perished because of their ignorance, the word Kamikaze does not mean recklessness but good fortune. You displayed a little ignorance of Japanese culture, but I won't abuse you over it.

Just have a go at my question just beneath this topic referring to DMO Bulk Copy and transactions because I am really stuck, need some help, and nobody has replied.
Go to Top of Page

JERICHO
Starting Member

18 Posts
Posted - 2002-10-10 : 02:18:32
hey guys, please do not do unnecessary quarrel over small issues, anyway i got the solution way before hand and posting to the forum is to make sure of it cos i dun wish to play a fool with my company datas, and duplicate copy of the data can let me do my enhancement and development without affecting the current system and datas.
rihardh, u are right in a certain way and i like comments from ppl and i do accept comments from you too, u are right i am a beginner but to be frank with you this may be a simple task but i had not touch database since school days and hope u dun mind people like me who is 'NEWBIE' from posting 'SIMPLE' question.
THanks for all ur help.i really appreciate it,
ValterBorges,Merkin,Andraax,jhunt,page47
Go to Top of Page

M.E.
Aged Yak Warrior

539 Posts
Posted - 2002-10-10 : 13:59:34
Just something for ya Jericho... One of my first posts on this board was me asking for help understanding the differences between left and inner joins. I'm pretty sure I got called a newbie or a paper DBA by pretty close to everyone. Heh, actually... I'm pretty sure some people on this forum read my attempts to give help and call me a newbie . But it's because of these simple questions that I've gotten alot better with my knowledge.

I guess all I'm saying is keep reading and posting and don't get discouraged by these 'go read a book you newbie' comments, keep reading these threads and keep posting any questions ya got. You'd be surprised of the amount of info you can pick up from this site.

Mark

-----------------------
SQL isn't just a hobby, It's an addiction
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site