Backing up SP's and Functions...

Hello,

I want to write a batch file which gets the backup of the SP's,Functions,Views and Tables which belongs to me.Is there a utility to do this?

The best option may be using one of the excellent third party products. Or, try these scripts and see if you can convert one of them for your usage.

DDL -Script Database to File
http://www.wardyit.com/blog/blog/archive/2006/07/21/133.aspx
http://www.sqlteam.com/publish/scriptio
http://www.aspfaq.com/etiquette.asp?id=5006
http://www.codeproject.com/dotnet/ScriptDatabase.asp
http://www.nigelrivett.net/DMO/DMOScriptAllDatabases.html
http://rac4sql.net/qalite_main.asp

I'd recommend one of the third party products, such as SQL Script from www.ApexSQL.com.

sql

Backing up Only the Table data?

How can i just backup the table data of a database. without the sp, views Please its Veeeeeeeery Urgentetc...

You can use BCP to export the data on a table by table basis.

|||

I'm not sure what you are attempting to accomplish -you might find the Database Publishing Wizard useful.

Database Publishing Wizard
http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

|||I want To Backup only the data in a database. without the Sp views etc.. the thing is , i wanna do this by using t-sq. can u pleeeeese help me. in the mean time i wanna the command for to stop a database running. can u pleeeese help me ASAP. im in the middle of aa development. thank you. from|||

Well,

If you are not going to read and try out our previous suggestions, then we probably aren't going to offer you much more.

You have two good suggestions -tell us what is wrong with them so we will know that you at least tried them.

|||sorry for nt telling you details, bt i cant do that method. because i wanna do that from the t_sql commands. imm building a advanced database maintenance module from vb6. so i cant use thirdparty app,lications. i wanna do it by the application it self. and please help me. i tried aal ur suggestions. even i cant do them , i serched how to do them in da net. so please help me.

Back Up Strategy

Would like to take your valuable views on ,What’s the best strategy for
Database back up and files back up:-
I have few options:-
? Using Database Maintenance plan
? Using State Store
? On SQL Server, using Differential on daily & Complete back on wend..
? Other options :-
Thanks...Hi,
Thanks for your post!
My understanding of your issue is:
You wanted the best strategy for SQL Server database backup.
If I have misunderstood, please let me know.
Generally, different situations require different backup strategies.
It's difficult to say which one is the best.
You might back up your database frequently if your system is in an online
transaction processing (OLTP) environment.
You might back up your database less frequently if your system has little
activity or is used primarily for decision support.
You should schedule backups when SQL Server is not in the process of
being heavily updated.
After you determine your backup strategy, you can automate the process by
using the Database Maintenance Plan Wizard.
Also, you may refer to:
http://msdn.microsoft.com/library/d...-us/adminsql/ad
_bkprst_63eh.asp
http://www.microsoft.com/technet/pr...n/sqlbackuprest
.mspx
http://msdn.microsoft.com/library/d...-us/adminsql/ad
_bkprst_7drn.asp
If you have any other concerns, please feel free to let me know. It's my
pleasure to be of assistance.
+++++++++++++++++++++++++++
Charles Wang
Microsoft Online Partner Support
+++++++++++++++++++++++++++
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a w to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others:
https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/defaul...rnational.aspx.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

Avoid Cross Database Views in Data Warehouse

We have a relational database (rd) and a data warehouse (dw). This dw has a table (tw) with all key fields (dimension keys) and metric related (measures) fields. This table is populated with monthly data each month. The tw is joined to various look up views present in the dw to obtain name fields from rd. The DBA wants me to remove the look up views. I now have following 2 options that I can think of –

1) Further de-normalize the tw and store the name fields as well. However, there are two issues with this option –

a. The size of tw will grow tremendously.
b. We are storing monthly data and the values in the name fields may change after some time. Then we will have to put in additional views/objects to obtain the latest name.

2) Using ETL, obtain the copy of rd tables overnight in dw. We will then join tw with these tables and there will no longer be cross database joins. However, this will be a burden on maintenance and support.

As of now these are the possible options I can come up with. Which one would you suggest and why? If you have another option, please let me know.

Thank you all in advance,

sajmeraWe have a relational database (rd) and a data warehouse (dw).
No you don't. You have a datamart. If you had a real data warehouse schema you would not have these issues.

The DBA wants me to remove the look up views.
Why?

2) Using ETL, obtain the copy of rd tables overnight in dw. We will then join tw with these tables and there will no longer be cross database joins. However, this will be a burden on maintenance and support.
A data warehouse (or datamart) should be self-contained, and not rely upon pulling dynamic data from other systems. Maintenance and support are necessary requirements of a data stores.