Backup a table? 2

[pk400i]

HI I want to backup a table with 'some' data, not all the data. The developer wants to see all the fields and everything. I did a CSV file but he says this is not what he means.
How does one make such a backup, for SQL Server 2005?

 

[gmmastros]

You cannot backup just some of the data. It's all or nothing.

The simplest way to backup your database is:

Backup Database [Your database name here] To Disk = 'C:\MyBackup.bak'

Replace with your database name and run this in a query window.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[bborissov]

As George said it is not possible, but you can create Temporary DB, select * from that table and then backup that temp DB. Something like:

CREATE DATABASE TempBackup
SELECT * INTO TempBackup.dbo.NameOfTable FROM YourDb.dbo.NameOfTable
--- George's code goes here
Backup Database TempBackUp To Disk = 'C:\MyBackup.bak'

DROP DATABASE TempBackup

NOT TESTED!!!!


Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[pk400i]

Thank you. I was getting an error message that TempBackup does not exist there on line 2.

CREATE DATABASE TempBackup
SELECT * INTO TempBackup.dbo.rm00101 FROM pbs.dbo.rm00101
Backup Database [Tempbackup] To Disk = 'C:\MyBackup.bak'
Drop Database Tempbackup

 

[gmmastros]

try putting so GO's in there:

CREATE DATABASE TempBackup
go
SELECT * INTO TempBackup.dbo.rm00101 FROM pbs.dbo.rm00101
go
Backup Database [Tempbackup] To Disk = 'C:\MyBackup.bak'
go
Drop Database Tempbackup

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[pk400i]

Would it be possible to only copy a set number of rows, something like backup from row n to n?

 

[gmmastros]

SELECT * INTO TempBackup.dbo.rm00101 FROM pbs.dbo.rm00101
[!]Where row between 10 and 20[/!]

You can add any where clause you want. What I show above is just an example.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom