Tuesday, March 27, 2012

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.

No comments:

Post a Comment