Solved

Backing up partial database from sqlserver

Posted on 2004-04-06
6
175 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
0
Comment
Question by:princemahesh
  • 3
  • 2
6 Comments
 
LVL 11

Expert Comment

by:shaneholmes
Comment Utility
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
 

Author Comment

by:princemahesh
Comment Utility
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
 
LVL 11

Expert Comment

by:shaneholmes
Comment Utility
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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 1

Accepted Solution

by:
Ridey earned 100 total points
Comment Utility
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
 
LVL 1

Expert Comment

by:Ridey
Comment Utility
>> 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
 
LVL 1

Expert Comment

by:Ridey
Comment Utility
thanks princemahesh

I'm Glad I could help
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now