Backing up partial database from sqlserver

Hi

I have to take a backup of sqlserver database, but not the complete data. I need all the tables but i need to filtered the data.
Also all the views and indexes with the tables.

if someone could give me some example that would be great.

Mahesh
princemaheshAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
RideyConnect With a Mentor Commented:
Can I suggest the following

select  top 1000 * into TempBackupTable from Table

Then do your backup on the TempBackUpTable

drop table TempBackupTable

Note : TempBackupTable must not be defined as @TempBackupTable as this will only stay for the length of your session and will not eb available there after.

Kind Regards
0
 
shaneholmesCommented:
This question has been visited before, please look here for a couple of suggestions'
preferably, the accepted solution:

http://www.experts-exchange.com/Programming/Programming_Languages/Delphi/Q_20691981.html?query=backup+sqlserver+database&searchType=topic

Shane
0
 
princemaheshAuthor Commented:
thanks shaneholmes

This will create the backup....is their a way if i don't want to take the backup of entire database, but some part of data only.


0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
shaneholmesCommented:
Um, you could search for backup components which support SQLServer. Most of these components allow for the selection of tables/records. However, I don't kno wof any off the top of my head

Did you try looking for any components?

If not, try the following places (do a search for backup)


http://delphi.icm.edu.pl/  {delphi Super Page}
ww1.torry.ru (www.torry.net)

www.delphipages.com
www.delphi32.com


Shane
0
 
RideyCommented:
>> Note : TempBackupTable must not be defined as @TempBackupTable as this will only stay for the length of your session and will not eb available there after.

Sorry my mistake it should read

Note : TempBackupTable must not be defined as #TempBackupTable as this will only stay for the length of your session and will not eb available there after.
0
 
RideyCommented:
thanks princemahesh

I'm Glad I could help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.