We help IT Professionals succeed at work.

Backing up partial database from sqlserver

princemahesh
princemahesh asked
on
201 Views
Last Modified: 2010-04-05
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
Comment
Watch Question

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

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

Shane

Author

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.


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
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Commented:
>> 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.

Commented:
thanks princemahesh

I'm Glad I could help
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.