Mark Forums Read

Make a development copy af a DB

Go Back

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Reply

Page 1 of 4

1

#1

Old

KSor

Posts: n/a

Make a development copy af a DB - 08-18-2008 , 04:18 AM

I want to copy a database to the same server but with a new name - in fact I
want to make a copy for developing

Can the "copy database wizard" be used for this ?

(Some users tells me, that the "copy database wizard" corrupts the source -
is that a fact or .. ?)

Best regards
KSor, Denmark

Reply With Quote

#2

Old

Andrew J. Kelly

Posts: n/a

Re: Make a development copy af a DB - 08-18-2008 , 07:36 AM

The easiest way is to use a backup and restore but make sure to restore it
to a different name and folder. If you have never done this before you may
want to test this on another server first. I also don't recommend doing
development on the production server either.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"KSor" <keld.soerensenDELETETHIS (AT) psa (DOT) dk> wrote

Quote:

I want to copy a database to the same server but with a new name - in fact
I want to make a copy for developing

Can the "copy database wizard" be used for this ?

(Some users tells me, that the "copy database wizard" corrupts the
source - is that a fact or .. ?)

Best regards
KSor, Denmark

Reply With Quote

#3

Old

Andrew J. Kelly

Posts: n/a

Re: Make a development copy af a DB - 08-18-2008 , 07:36 AM

The easiest way is to use a backup and restore but make sure to restore it
to a different name and folder. If you have never done this before you may
want to test this on another server first. I also don't recommend doing
development on the production server either.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"KSor" <keld.soerensenDELETETHIS (AT) psa (DOT) dk> wrote

Quote:

I want to copy a database to the same server but with a new name - in fact
I want to make a copy for developing

Can the "copy database wizard" be used for this ?

(Some users tells me, that the "copy database wizard" corrupts the
source - is that a fact or .. ?)

Best regards
KSor, Denmark

Reply With Quote

#4

Old

Andrew J. Kelly

Posts: n/a

Re: Make a development copy af a DB - 08-18-2008 , 07:36 AM

The easiest way is to use a backup and restore but make sure to restore it
to a different name and folder. If you have never done this before you may
want to test this on another server first. I also don't recommend doing
development on the production server either.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"KSor" <keld.soerensenDELETETHIS (AT) psa (DOT) dk> wrote

Quote:

I want to copy a database to the same server but with a new name - in fact
I want to make a copy for developing

Can the "copy database wizard" be used for this ?

(Some users tells me, that the "copy database wizard" corrupts the
source - is that a fact or .. ?)

Best regards
KSor, Denmark

Reply With Quote

#5

Old

Andrew J. Kelly

Posts: n/a

Re: Make a development copy af a DB - 08-18-2008 , 07:36 AM

The easiest way is to use a backup and restore but make sure to restore it
to a different name and folder. If you have never done this before you may
want to test this on another server first. I also don't recommend doing
development on the production server either.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"KSor" <keld.soerensenDELETETHIS (AT) psa (DOT) dk> wrote

Quote:

I want to copy a database to the same server but with a new name - in fact
I want to make a copy for developing

Can the "copy database wizard" be used for this ?

(Some users tells me, that the "copy database wizard" corrupts the
source - is that a fact or .. ?)

Best regards
KSor, Denmark

Reply With Quote

#6

Old

Andrew J. Kelly

Posts: n/a

Re: Make a development copy af a DB - 08-18-2008 , 07:36 AM

The easiest way is to use a backup and restore but make sure to restore it
to a different name and folder. If you have never done this before you may
want to test this on another server first. I also don't recommend doing
development on the production server either.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"KSor" <keld.soerensenDELETETHIS (AT) psa (DOT) dk> wrote

Quote:

I want to copy a database to the same server but with a new name - in fact
I want to make a copy for developing

Can the "copy database wizard" be used for this ?

(Some users tells me, that the "copy database wizard" corrupts the
source - is that a fact or .. ?)

Best regards
KSor, Denmark

Reply With Quote

#7

Old

Andrew J. Kelly

Posts: n/a

Re: Make a development copy af a DB - 08-18-2008 , 07:36 AM

The easiest way is to use a backup and restore but make sure to restore it
to a different name and folder. If you have never done this before you may
want to test this on another server first. I also don't recommend doing
development on the production server either.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"KSor" <keld.soerensenDELETETHIS (AT) psa (DOT) dk> wrote

Quote:

I want to copy a database to the same server but with a new name - in fact
I want to make a copy for developing

Can the "copy database wizard" be used for this ?

(Some users tells me, that the "copy database wizard" corrupts the
source - is that a fact or .. ?)

Best regards
KSor, Denmark

Reply With Quote

#8

Old

Andrew J. Kelly

Posts: n/a

Re: Make a development copy af a DB - 08-18-2008 , 07:36 AM

The easiest way is to use a backup and restore but make sure to restore it
to a different name and folder. If you have never done this before you may
want to test this on another server first. I also don't recommend doing
development on the production server either.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"KSor" <keld.soerensenDELETETHIS (AT) psa (DOT) dk> wrote

Quote:

I want to copy a database to the same server but with a new name - in fact
I want to make a copy for developing

Can the "copy database wizard" be used for this ?

(Some users tells me, that the "copy database wizard" corrupts the
source - is that a fact or .. ?)

Best regards
KSor, Denmark

Reply With Quote

#9

Old

Andrew J. Kelly

Posts: n/a

Re: Make a development copy af a DB - 08-18-2008 , 07:36 AM

The easiest way is to use a backup and restore but make sure to restore it
to a different name and folder. If you have never done this before you may
want to test this on another server first. I also don't recommend doing
development on the production server either.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"KSor" <keld.soerensenDELETETHIS (AT) psa (DOT) dk> wrote

Quote:

I want to copy a database to the same server but with a new name - in fact
I want to make a copy for developing

Can the "copy database wizard" be used for this ?

(Some users tells me, that the "copy database wizard" corrupts the
source - is that a fact or .. ?)

Best regards
KSor, Denmark

Reply With Quote

#10

Old

Andrew J. Kelly

Posts: n/a

Re: Make a development copy af a DB - 08-18-2008 , 07:36 AM

The easiest way is to use a backup and restore but make sure to restore it
to a different name and folder. If you have never done this before you may
want to test this on another server first. I also don't recommend doing
development on the production server either.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"KSor" <keld.soerensenDELETETHIS (AT) psa (DOT) dk> wrote

Quote:

I want to copy a database to the same server but with a new name - in fact
I want to make a copy for developing

Can the "copy database wizard" be used for this ?

(Some users tells me, that the "copy database wizard" corrupts the
source - is that a fact or .. ?)

Best regards
KSor, Denmark

Reply With Quote

Reply

Page 1 of 4

1

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.