making copy of 6.5 database to 7 or 2000

I have a 6.5 db that I want to create a copy of, I can move it to either
a machine running 7 or 2000. I am more used to doing this in Oracle so
pls bear with me...

I don't want to have any downtime on the 6.5 db, so I'm thinking perhaps
import is the best way to go? I am assuming that 6.5 backups are not
comaptible with either 7 or 2000 restore, or I'd go that route.

The database in question is fairly simple, pretty well just tables full
of data, no stored procs...

suggestions?

TIAHi

There are significant architectural differences between 6.5 and SQL
7/2000, and as you suppose the backups are not upgradeable. This
really only leaves you with the choice of DTS or script/BCP. If you
don't want to impact the live system I suggest that you restore a
backup into a separate database, preferably on a second machine.

John

Glen A Stromquist <glen_stromquist@.no.spam.yahoo.com> wrote in message news:<Qkfob.7041$EY3.2756@.edtnps84>...
> I have a 6.5 db that I want to create a copy of, I can move it to either
> a machine running 7 or 2000. I am more used to doing this in Oracle so
> pls bear with me...
> I don't want to have any downtime on the 6.5 db, so I'm thinking perhaps
> import is the best way to go? I am assuming that 6.5 backups are not
> comaptible with either 7 or 2000 restore, or I'd go that route.
> The database in question is fairly simple, pretty well just tables full
> of data, no stored procs...
> suggestions?
> TIA|||Glen A Stromquist <glen_stromquist@.no.spam.yahoo.com> wrote in message news:<Qkfob.7041$EY3.2756@.edtnps84>...
> I have a 6.5 db that I want to create a copy of, I can move it to either
> a machine running 7 or 2000. I am more used to doing this in Oracle so
> pls bear with me...
> I don't want to have any downtime on the 6.5 db, so I'm thinking perhaps
> import is the best way to go? I am assuming that 6.5 backups are not
> comaptible with either 7 or 2000 restore, or I'd go that route.
> The database in question is fairly simple, pretty well just tables full
> of data, no stored procs...
> suggestions?
> TIA

You can't restore 6.5 databases on SQL7/2000 (you can restore a SQL7
backup on SQL2000). If the database is quite simple, though, then it
should be straightforward to use BCP/DTS to transfer the data - script
the table structures, create them on the destination server, then copy
the data. DTS will create the tables for you, in fact. Or if the
volume of data isn't large, you could even create a linked server to
the SQL6.5 server, and simply INSERT... SELECT...

Simon|||I did not trust the microsoft upgrade wiz so what I did to move sql 6.5 to
2000 was:

1. Install all the SQL 2000 servers with a common collation order -
(Latin_General I think)

2. Create the DB name on SQL 2000

3. Script the tables in 6.5 with just create & object permissions

4. Install the script on 2000 and fix the application/script for field name
problems found. (Eg fields named Percent)

5. Use DTS to take the data from 6.5 to 2000 into these tables.

6. Script just primary key, indexes, triggers, DRI.

7. Sorted out the primary keys to install first on 2000. Then install the
indexes, triggers, foreign keys.

8. Switch over the users by changing the computer names of both machine -
such that the new machine gets the old machine's name.

With tested run of the steps 1 to 7 found that I only needed 30 min down
time so I got management to approve a 60 min downtime.

"Glen A Stromquist" <glen_stromquist@.no.spam.yahoo.com> wrote in message
news:Qkfob.7041$EY3.2756@.edtnps84...
> I have a 6.5 db that I want to create a copy of, I can move it to either
> a machine running 7 or 2000. I am more used to doing this in Oracle so
> pls bear with me...
> I don't want to have any downtime on the 6.5 db, so I'm thinking perhaps
> import is the best way to go? I am assuming that 6.5 backups are not
> comaptible with either 7 or 2000 restore, or I'd go that route.
> The database in question is fairly simple, pretty well just tables full
> of data, no stored procs...
> suggestions?
> TIA|||Hi

A couple of extras..

I would suggest that you keep your code in souce code control.
I would use BCP instead of DTS as you can recover/re-run from intermediate
stages.

John

"IanT" <IanNoSpam@.NoSpam.com.au> wrote in message
news:bo0doc$i2m$1@.perki.connect.com.au...
> I did not trust the microsoft upgrade wiz so what I did to move sql 6.5 to
> 2000 was:
> 1. Install all the SQL 2000 servers with a common collation order -
> (Latin_General I think)
> 2. Create the DB name on SQL 2000
> 3. Script the tables in 6.5 with just create & object permissions
> 4. Install the script on 2000 and fix the application/script for field
name
> problems found. (Eg fields named Percent)
> 5. Use DTS to take the data from 6.5 to 2000 into these tables.
> 6. Script just primary key, indexes, triggers, DRI.
> 7. Sorted out the primary keys to install first on 2000. Then install the
> indexes, triggers, foreign keys.
> 8. Switch over the users by changing the computer names of both machine -
> such that the new machine gets the old machine's name.
>
> With tested run of the steps 1 to 7 found that I only needed 30 min down
> time so I got management to approve a 60 min downtime.
>
>
> "Glen A Stromquist" <glen_stromquist@.no.spam.yahoo.com> wrote in message
> news:Qkfob.7041$EY3.2756@.edtnps84...
> > I have a 6.5 db that I want to create a copy of, I can move it to either
> > a machine running 7 or 2000. I am more used to doing this in Oracle so
> > pls bear with me...
> > I don't want to have any downtime on the 6.5 db, so I'm thinking perhaps
> > import is the best way to go? I am assuming that 6.5 backups are not
> > comaptible with either 7 or 2000 restore, or I'd go that route.
> > The database in question is fairly simple, pretty well just tables full
> > of data, no stored procs...
> > suggestions?
> > TIA

making a local copy

hi I have a SQL DB hosted in a hosting company, I want to create a local copy
in my pc, what is the best way to do it.
I tried to make a backup but it seem that the backup can be done only in the
Hosting machine so I could not do it.
thks
Ken
Your best bet is to have them send you a copy of the latest full backup.
Maybe they have an FTP site where you can access it.
Andrew J. Kelly SQL MVP
"Kenny M." <KennyM@.discussions.microsoft.com> wrote in message
news:87AEBE9D-C237-4679-8734-405905D7C3A9@.microsoft.com...
> hi I have a SQL DB hosted in a hosting company, I want to create a local
> copy
> in my pc, what is the best way to do it.
> I tried to make a backup but it seem that the backup can be done only in
> the
> Hosting machine so I could not do it.
> thks
>
> --
> Ken
|||I use DTS to copy the db from a web host to a local SQL Server. You're
right, backup requires the server to have access to the drive where you
store the backup file, and it can't get to your computer.
"Kenny M." <KennyM@.discussions.microsoft.com> wrote in message
news:87AEBE9D-C237-4679-8734-405905D7C3A9@.microsoft.com...
> hi I have a SQL DB hosted in a hosting company, I want to create a local
> copy
> in my pc, what is the best way to do it.
> I tried to make a backup but it seem that the backup can be done only in
> the
> Hosting machine so I could not do it.
|||Hi
You may want to talk to the hosting company to make the backup downloadable
or have it ftp'd (with the appropriate security in place).
John
"Kenny M." <KennyM@.discussions.microsoft.com> wrote in message
news:87AEBE9D-C237-4679-8734-405905D7C3A9@.microsoft.com...
> hi I have a SQL DB hosted in a hosting company, I want to create a local
> copy
> in my pc, what is the best way to do it.
> I tried to make a backup but it seem that the backup can be done only in
> the
> Hosting machine so I could not do it.
> thks
>
> --
> Ken
|||Thks all of you!!!
"Kenny M." wrote:

> hi I have a SQL DB hosted in a hosting company, I want to create a local copy
> in my pc, what is the best way to do it.
> I tried to make a backup but it seem that the backup can be done only in the
> Hosting machine so I could not do it.
> thks
>
> --
> Ken

Making a copy of an SQL 7 database into an MSDE environment

We have developed an application for Small Business
Server (SQL) on a system that is running MSDE. All
programming and testing was conducted on a remote,
standalone system, and when completed, we were able to
move appropriate copies to the LAN via an external 80GB
Western Digital USB attached portable drive.
Is it possible to copy one or more or the SQL databases
(all tables) from the SBS SQL server to an MSDE system?
(ie a network attached laptop).
I would appreciate your assistance and comments.
Regards...Dave K.
hi Dave,
"dkalling" <dkalling@.cnx2.com> ha scritto nel messaggio
news:04c001c4eddc$579de490$a401280a@.phx.gbl
> We have developed an application for Small Business
> Server (SQL) on a system that is running MSDE. All
> programming and testing was conducted on a remote,
> standalone system, and when completed, we were able to
> move appropriate copies to the LAN via an external 80GB
> Western Digital USB attached portable drive.
> Is it possible to copy one or more or the SQL databases
> (all tables) from the SBS SQL server to an MSDE system?
> (ie a network attached laptop).
> I would appreciate your assistance and comments.
> Regards...Dave K.
as you can't use DTS to manage MSDE instances (and more you say that your
SQL Server is a version 7.0 server), you have to rely on backup/restore
and/or sp_detach_db/sp_attach_db solutions
please keep in mind you will probably experiencing orphaned users problems
after that operation(s), you can resolve using system stored procedure
sp_change_users_login
(http://www.sqlservercentral.com/colu...okenlogins.asp)
you can move users databases this way only from 7.0 version to 2000 version,
and not vice versa
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

makeing a db backup for transport

I have a production machine and a development machine.. I need to have a
copy of the SQL database to follow me around with the laptop development
machine, what is the best wat to make a copy of the production db onto the
laptop system? just importaing data with EM or is there some process that is
easier? (the dev machine has MSDE on it instead of sql server 2000 like the
production one has)"Brian Henry" <brianiup@.adelphia.net> wrote in message
news:OMocDNnjDHA.3612@.TK2MSFTNGP11.phx.gbl...
> I have a production machine and a development machine.. I need to have a
> copy of the SQL database to follow me around with the laptop development
> machine, what is the best wat to make a copy of the production db onto the
> laptop system? just importaing data with EM or is there some process that
is
> easier? (the dev machine has MSDE on it instead of sql server 2000 like
the
> production one has)
There are a couple of ways to do this...
- you could take a BACKUP of the production database and RESTORE to your
laptop.
- you could use the sp_detach_db to temporarily detach the database from the
production server, copy the files to your laptop, then use sp_attach_db to
re-attach the database on your server and laptop (see BOL for more details
on the syntax).
Steve|||An easier way is to stop the SQL server for a moment copy the files to the
laptop and attach these files to the SQL server instance on the laptop.
Invoking the sp_detach_db is not required.
Majid
"Steve Thompson" <SteveThompson@.nomail.please> wrote in message
news:u5OlZbnjDHA.2444@.TK2MSFTNGP09.phx.gbl...
> "Brian Henry" <brianiup@.adelphia.net> wrote in message
> news:OMocDNnjDHA.3612@.TK2MSFTNGP11.phx.gbl...
> > I have a production machine and a development machine.. I need to have a
> > copy of the SQL database to follow me around with the laptop development
> > machine, what is the best wat to make a copy of the production db onto
the
> > laptop system? just importaing data with EM or is there some process
that
> is
> > easier? (the dev machine has MSDE on it instead of sql server 2000 like
> the
> > production one has)
> There are a couple of ways to do this...
> - you could take a BACKUP of the production database and RESTORE to your
> laptop.
> - you could use the sp_detach_db to temporarily detach the database from
the
> production server, copy the files to your laptop, then use sp_attach_db to
> re-attach the database on your server and laptop (see BOL for more details
> on the syntax).
> Steve
>|||> Invoking the sp_detach_db is not required.
Attach is only guaranteed if you actually detached first. It might work even if you just "picked up
the files", but if you check BOL you find that BOL explicitly say that you should detach first.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Majid" <majid@.dynatechsolution.com> wrote in message news:uqCUvKGkDHA.4008@.TK2MSFTNGP11.phx.gbl...
> An easier way is to stop the SQL server for a moment copy the files to the
> laptop and attach these files to the SQL server instance on the laptop.
> Invoking the sp_detach_db is not required.
> Majid
>
> "Steve Thompson" <SteveThompson@.nomail.please> wrote in message
> news:u5OlZbnjDHA.2444@.TK2MSFTNGP09.phx.gbl...
> > "Brian Henry" <brianiup@.adelphia.net> wrote in message
> > news:OMocDNnjDHA.3612@.TK2MSFTNGP11.phx.gbl...
> > > I have a production machine and a development machine.. I need to have a
> > > copy of the SQL database to follow me around with the laptop development
> > > machine, what is the best wat to make a copy of the production db onto
> the
> > > laptop system? just importaing data with EM or is there some process
> that
> > is
> > > easier? (the dev machine has MSDE on it instead of sql server 2000 like
> > the
> > > production one has)
> >
> > There are a couple of ways to do this...
> >
> > - you could take a BACKUP of the production database and RESTORE to your
> > laptop.
> > - you could use the sp_detach_db to temporarily detach the database from
> the
> > production server, copy the files to your laptop, then use sp_attach_db to
> > re-attach the database on your server and laptop (see BOL for more details
> > on the syntax).
> >
> > Steve
> >
> >
>

Make a same copy of SQL Server to a new machine

Dear all,
Since my old server's harddisk drive nearly used up all the free
space, I need to copy it from new server. Can I simply copy all the dat and
log files to new server without detach it provided that there're no user
using it and after that I attach them back to new sql server? I'm afraid in
case there're something go wrong in my new server and I can still use the
old server. And how can I transfer my logins to new server? I read some
articles that it may has orphan users if without transferring them. Or if
anyone knows the proper procedures on coping data into new server. Please
help. Thanks
Best Rdgs
EllisSee if this helps: http://vyaskn.tripod.com/moving_sql_server.htm
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Ellis Yu" <ellis.yu@.transfield.com> wrote in message
news:ezwt5MlvEHA.3228@.TK2MSFTNGP12.phx.gbl...
> Dear all,
> Since my old server's harddisk drive nearly used up all the free
> space, I need to copy it from new server. Can I simply copy all the dat
and
> log files to new server without detach it provided that there're no user
> using it and after that I attach them back to new sql server? I'm afraid
in
> case there're something go wrong in my new server and I can still use the
> old server. And how can I transfer my logins to new server? I read some
> articles that it may has orphan users if without transferring them. Or if
> anyone knows the proper procedures on coping data into new server. Please
> help. Thanks
> Best Rdgs
> Ellis
>

Make a same copy of SQL Server to a new machine

Dear all,
Since my old server's harddisk drive nearly used up all the free
space, I need to copy it from new server. Can I simply copy all the dat and
log files to new server without detach it provided that there're no user
using it and after that I attach them back to new sql server? I'm afraid in
case there're something go wrong in my new server and I can still use the
old server. And how can I transfer my logins to new server? I read some
articles that it may has orphan users if without transferring them. Or if
anyone knows the proper procedures on coping data into new server. Please
help. Thanks
Best Rdgs
Ellis
See if this helps: http://vyaskn.tripod.com/moving_sql_server.htm
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Ellis Yu" <ellis.yu@.transfield.com> wrote in message
news:ezwt5MlvEHA.3228@.TK2MSFTNGP12.phx.gbl...
> Dear all,
> Since my old server's harddisk drive nearly used up all the free
> space, I need to copy it from new server. Can I simply copy all the dat
and
> log files to new server without detach it provided that there're no user
> using it and after that I attach them back to new sql server? I'm afraid
in
> case there're something go wrong in my new server and I can still use the
> old server. And how can I transfer my logins to new server? I read some
> articles that it may has orphan users if without transferring them. Or if
> anyone knows the proper procedures on coping data into new server. Please
> help. Thanks
> Best Rdgs
> Ellis
>

Make a same copy of SQL Server to a new machine

Dear all,
Since my old server's harddisk drive nearly used up all the free
space, I need to copy it from new server. Can I simply copy all the dat and
log files to new server without detach it provided that there're no user
using it and after that I attach them back to new sql server? I'm afraid in
case there're something go wrong in my new server and I can still use the
old server. And how can I transfer my logins to new server? I read some
articles that it may has orphan users if without transferring them. Or if
anyone knows the proper procedures on coping data into new server. Please
help. Thanks
Best Rdgs
EllisSee if this helps: http://vyaskn.tripod.com/moving_sql_server.htm
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Ellis Yu" <ellis.yu@.transfield.com> wrote in message
news:ezwt5MlvEHA.3228@.TK2MSFTNGP12.phx.gbl...
> Dear all,
> Since my old server's harddisk drive nearly used up all the free
> space, I need to copy it from new server. Can I simply copy all the dat
and
> log files to new server without detach it provided that there're no user
> using it and after that I attach them back to new sql server? I'm afraid
in
> case there're something go wrong in my new server and I can still use the
> old server. And how can I transfer my logins to new server? I read some
> articles that it may has orphan users if without transferring them. Or if
> anyone knows the proper procedures on coping data into new server. Please
> help. Thanks
> Best Rdgs
> Ellis
>

Make a copy of SQL Server database

I'm trying to make a copy of our 2005 SQL Server production database (25 meg) so we can install it in a new office being set up in another state. I have right clicked on the database I want to copy, selected Tasks, then option Copy Database... I'm trying to put the copy on the same server, and I am doing this work signed into the Management Studio as "sa" The wizard creates 5 steps, the first 4 run ok, then the 5th step runs for 10 to 20 seconds, then quits. The message says to look in the log on the server for the reason it quit. The only log I can find is the Error Logs at the bottom of the Object Explorer window. I look into the current log, then select the SQL Server log, the current one. There is only one line in here about the copy I just tried, and it only says "Starting up database XXXXXXXX" which is the database I'm trying to create through the copy process. Within Database Mail, SQL Agent, and Windows NT log lines, I can not find any reference to the copy job that just bombed.

Needless to say, I'm VERY new to all of this SQL Server admin stuff. If someone could point me in the right direction, it would really help!

Thanks!make a backup and restore it to your new server.|||Make a copy_only backup. Documentation (http://msdn2.microsoft.com/en-us/library/ms191495.aspx) is available at MSDN.

Make a copy of SQL DB and update/change stored procedures

Can I make a copy of my development database DEV on same SQL SERVER machine, rename it to TEST and stored procedures to be updated automatically for statements like

UPDATE [DEV].[dbo].[Company]

SET [company_name]= @.company_name

to become

UPDATE [TEST].[dbo].[Company]

SET [company_name]= @.company_name

in order not to edit each individual stored procedure for updating it ?

Hi Chris,

You would have to use SQL Query Analyzer.

USE test
GO

CREATE PROCREDURE p_company_update
@.company_id INT,
@.company_name VARCHAR(64)
AS
SET NOCOUNT ON
UPDATE company
SET company_name = @.company_name
WHERE company_id = @.company_id
GO

Good Coding!

Javier Luna
http://guydotnetxmlwebservices.blogspot.com/

|||Thanks for your message.

Make a copy of parts of a ROW, but with a new Key.

Hi there,

I want to insert a new record into my database table, giving new field
values for all but one (an image field), which I can copied from an existing
record. The background to this is that I am allowing a user to create a new
"template" from an existing one, thus I want a new record, but also to copy
the existing template data blob into the new record.

My code looks like this, but obviously doesn't work (I don't supply a field
for the first field "ID" in my SELECT statement which should be a unique ID.
Obviously, I want SQL to automatically generate one for me!). Is there any
way to do this with SQL?

IF @.Error = 0
BEGIN
SELECT @.DateCreated,
@.Title,
@.Description,
@.Thumbnail,
ReportTemplate.Report

INTO

ReportTemplate

FROM

ReportTemplate

SET @.Error = @.@.ERROR
ENDI think I got it. Like this:

IF @.Error = 0
BEGIN
INSERT INTO
ReportTemplate
(
DateCreated,
Title,
Description,
IsStatic,
Thumbnail,
Report
)

SELECT

@.DateCreated,
@.Title,
@.Description,
@.IsStatic,
@.Thumbnail,
ReportTemplate.Report

FROM

ReportTemplate

WHERE

ReportTemplate.ID = @.ID

SET @.Error = @.@.ERROR
END

"Robin Tucker" <idontwanttobespammedanymore@.reallyidont.com> wrote in
message news:c635gr$483$1$8302bc10@.news.demon.co.uk...
> Hi there,
> I want to insert a new record into my database table, giving new field
> values for all but one (an image field), which I can copied from an
existing
> record. The background to this is that I am allowing a user to create a
new
> "template" from an existing one, thus I want a new record, but also to
copy
> the existing template data blob into the new record.
> My code looks like this, but obviously doesn't work (I don't supply a
field
> for the first field "ID" in my SELECT statement which should be a unique
ID.
> Obviously, I want SQL to automatically generate one for me!). Is there
any
> way to do this with SQL?
> IF @.Error = 0
> BEGIN
> SELECT @.DateCreated,
> @.Title,
> @.Description,
> @.Thumbnail,
> ReportTemplate.Report
> INTO
> ReportTemplate
> FROM
> ReportTemplate
> SET @.Error = @.@.ERROR
> END

make a copy of database

Hi:

I have installed sql server 2005 express and SQL Server Management Studio Express

How can I generate a database from another copying the structure and data?

For example I have a database named Customers, I need to make a copy of Customers named Customers2. Customers2 also will be attached to the same Database Engine Server where Customers is attached.

How I Can do it?

Thanks!

P.S.

I tryied to make a copy of mdf an ldf files from Windows Explorer and renamed these files but I could not attach to the same Database Engine Server because I got an error.

The easiest way to do it is with the Backup and Restore Wizard because during restore you can change the name of the new one to customer2, I do it all the time, email the .bak or restore the .bak with a new name for a different department. If you don't have the SQL Server Express Advanced download it from the link below to use the Backup and Restore Wizard. Hope this helps.

http://msdn.microsoft.com/vstudio/express/sql/download/

make a copy of a db

I need to restore a copy of database to a new db name

i'm trying by creating a new db and restoring by doing

RESTORE DATABASE [userr] FROM DISK = N'D:\sqlbackups\user.bak' WITH FILE = 4, NOUNLOAD, STATS = 10
GO

i'm getting an error

Msg 3154, Level 16, State 4, Line 1
The backup set holds a backup of a database other than the existing 'userr' database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

What's the best way to do this?Apparently what you believe to be FILE = 4 and what the RESTORE finds in FILE = 4 is not the database you believe it to be.

Post the results of RESTORE HEADERONLY for the backup device please, and let's work from there.

BTW is the name of the database you are looking for "user" or "userr"?|||If this restore is going on the same instance as the original database, you will also need to move the physical files in the restore command.|||what's restore headeronly?

i'm trying to restore a backup from user to userr|||i'm restoring to a new db.
I don't want to lose my backups or touch my regular db in anyway

what's the best way to do this?|||what's restore headeronly?

i'm trying to restore a backup from user to userr

Check BOL!!|||If this restore is going on the same instance as the original database, you will also need to move the physical files in the restore command.

True, but I figure one problem at a time ... the RESTORE command, as he provided it, is trying to pull one backup out of a backup set ... a database named 'userr' ... and RESTORE says it is not at file position 4. Once we find the correct backup, we will work with "WITH MOVE".|||Yeah, but userr is the destination name, not the source name. I agree there may be a problem with the backup file (such as no fileID 4), but restore should pick up whatever backup is in slot 4, and restore it under the new name. I have not fiddled with this bit, since backing up everything to one file is a bit riskier than I like, so I have never had a reason to experiment with it.|||so what is the best way to do this - I urgently need to restore to a new db.|||why dont you use the restore option from enterprise manager... It is lot more easier...|||Backup and restore is the best way.

Make a backup of a Table

What is the best way (short of backing up the entire DB) to make a copy of a Table so that It can be easily restored. We have a table that we want to make some serious changes to, but I want to make sure I can restore if if I need to (if the changes don't work)check out bcp.exe

http://msdn2.microsoft.com/en-us/library/ms162802.aspx|||For some $$ (but not $$$), there are several vendors with products that permit object level recovery within SQL databases.

SQL Litespeed is one that has saved my bacon on at least two occasions.

Regards,

hmscott|||What is the best way (short of backing up the entire DB) to make a copy of a Table so that It can be easily restored. easiest way --select *
into my_backup_table
from my_live_table|||Ditto that...|||that's not really a backup though.

in my mind a backup needs to be a separate file, preferrably on a separate disk.|||original post didn't ask for a "backup" -- it asked for "the best way to make a copy of a Table so that It can be easily restored"

by that definition, the solution in post #4 fits the requirement quite nicely :)|||subject of the post states "Make a backup of a Table"|||yeah, but you're thinking of backup in the technical (geekspeak) sense, i'm guessing jpotucek was thinking of backup in the generic sense of making a copy in case something goes wrong

:)|||heh, ok. but isn't this a technical forum for geeks?

:)|||...obviously you've missed a few infamous posts...