Mark Forums Read

Copy a table in SQL Server 2005

Go Back

microsoft.public.sqlserver.server microsoft.public.sqlserver.server

Reply

Page 2 of 10

2

#11

Old

Uri Dimant

Posts: n/a

Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:25 AM

David
You can script out (with the data) the table and save it on the disk.

"David" <someone (AT) someisp (DOT) com> wrote

Hello all

I want to make a copy of a table in SQL Server 2005, a back-up of my table
if you will. I don't see any way of doing this, I am I right in assuming
that one can't copy a table in an SQL Sever 2005 database?

ie: MyTable -> MyTableCOPY = 2 Tables in the same database

Thank you for your time.

Regards

David

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Reply With Quote

#12

Old

Uri Dimant

Posts: n/a

Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:25 AM

David
You can script out (with the data) the table and save it on the disk.

"David" <someone (AT) someisp (DOT) com> wrote

Hello all

I want to make a copy of a table in SQL Server 2005, a back-up of my table
if you will. I don't see any way of doing this, I am I right in assuming
that one can't copy a table in an SQL Sever 2005 database?

ie: MyTable -> MyTableCOPY = 2 Tables in the same database

Thank you for your time.

Regards

David

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Reply With Quote

#13

Old

Uri Dimant

Posts: n/a

Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:25 AM

David
You can script out (with the data) the table and save it on the disk.

"David" <someone (AT) someisp (DOT) com> wrote

Hello all

I want to make a copy of a table in SQL Server 2005, a back-up of my table
if you will. I don't see any way of doing this, I am I right in assuming
that one can't copy a table in an SQL Sever 2005 database?

ie: MyTable -> MyTableCOPY = 2 Tables in the same database

Thank you for your time.

Regards

David

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Reply With Quote

#14

Old

Uri Dimant

Posts: n/a

Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:30 AM

Leon
If the database got corrupted you are still not be able to get back the
table. I think the way to save the datai is having proper backup of the
database or if the database is big, just script out into the text file the
table and keep it on the disk.

"Leon Mayne" <leon (AT) rmv_me (DOT) mvps.org> wrote

Quote:

"David" <someone (AT) someisp (DOT) com> wrote in message
news

p.t4y5ugvcrasovn (AT) pavilion (DOT) ..
I want to make a copy of a table in SQL Server 2005, a back-up of my
table if you will. I don't see any way of doing this, I am I right in
assuming that one can't copy a table in an SQL Sever 2005 database?

Just use
select * into newtable from oldtable

Reply With Quote

#15

Old

Uri Dimant

Posts: n/a

Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:30 AM

Leon
If the database got corrupted you are still not be able to get back the
table. I think the way to save the datai is having proper backup of the
database or if the database is big, just script out into the text file the
table and keep it on the disk.

"Leon Mayne" <leon (AT) rmv_me (DOT) mvps.org> wrote

Quote:

"David" <someone (AT) someisp (DOT) com> wrote in message
news

p.t4y5ugvcrasovn (AT) pavilion (DOT) ..
I want to make a copy of a table in SQL Server 2005, a back-up of my
table if you will. I don't see any way of doing this, I am I right in
assuming that one can't copy a table in an SQL Sever 2005 database?

Just use
select * into newtable from oldtable

Reply With Quote

#16

Old

Uri Dimant

Posts: n/a

Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:30 AM

Leon
If the database got corrupted you are still not be able to get back the
table. I think the way to save the datai is having proper backup of the
database or if the database is big, just script out into the text file the
table and keep it on the disk.

"Leon Mayne" <leon (AT) rmv_me (DOT) mvps.org> wrote

Quote:

"David" <someone (AT) someisp (DOT) com> wrote in message
news

p.t4y5ugvcrasovn (AT) pavilion (DOT) ..
I want to make a copy of a table in SQL Server 2005, a back-up of my
table if you will. I don't see any way of doing this, I am I right in
assuming that one can't copy a table in an SQL Sever 2005 database?

Just use
select * into newtable from oldtable

Reply With Quote

#17

Old

Uri Dimant

Posts: n/a

Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:30 AM

Leon
If the database got corrupted you are still not be able to get back the
table. I think the way to save the datai is having proper backup of the
database or if the database is big, just script out into the text file the
table and keep it on the disk.

"Leon Mayne" <leon (AT) rmv_me (DOT) mvps.org> wrote

Quote:

"David" <someone (AT) someisp (DOT) com> wrote in message
news

p.t4y5ugvcrasovn (AT) pavilion (DOT) ..
I want to make a copy of a table in SQL Server 2005, a back-up of my
table if you will. I don't see any way of doing this, I am I right in
assuming that one can't copy a table in an SQL Sever 2005 database?

Just use
select * into newtable from oldtable

Reply With Quote

#18

Old

Uri Dimant

Posts: n/a

Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:30 AM

Leon
If the database got corrupted you are still not be able to get back the
table. I think the way to save the datai is having proper backup of the
database or if the database is big, just script out into the text file the
table and keep it on the disk.

"Leon Mayne" <leon (AT) rmv_me (DOT) mvps.org> wrote

Quote:

"David" <someone (AT) someisp (DOT) com> wrote in message
news

p.t4y5ugvcrasovn (AT) pavilion (DOT) ..
I want to make a copy of a table in SQL Server 2005, a back-up of my
table if you will. I don't see any way of doing this, I am I right in
assuming that one can't copy a table in an SQL Sever 2005 database?

Just use
select * into newtable from oldtable

Reply With Quote

#19

Old

Uri Dimant

Posts: n/a

Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:30 AM

Leon
If the database got corrupted you are still not be able to get back the
table. I think the way to save the datai is having proper backup of the
database or if the database is big, just script out into the text file the
table and keep it on the disk.

"Leon Mayne" <leon (AT) rmv_me (DOT) mvps.org> wrote

Quote:

"David" <someone (AT) someisp (DOT) com> wrote in message
news

p.t4y5ugvcrasovn (AT) pavilion (DOT) ..
I want to make a copy of a table in SQL Server 2005, a back-up of my
table if you will. I don't see any way of doing this, I am I right in
assuming that one can't copy a table in an SQL Sever 2005 database?

Just use
select * into newtable from oldtable

Reply With Quote

#20

Old

Leon Mayne

Posts: n/a

Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:37 AM

"Uri Dimant" <urid (AT) iscar (DOT) co.il> wrote

Quote:

Leon
If the database got corrupted you are still not be able to get back the
table. I think the way to save the datai is having proper backup of the
database or if the database is big, just script out into the text file
the table and keep it on the disk.

Read the original post. They arn't talking about proper backups, they just
want a copy of the table in the same database.

Reply With Quote

Reply

Page 2 of 10

2

« 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.