take backup of sepcific tables

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

take backup of sepcific tables

Author

Topic

kirank
Yak Posting Veteran

58 Posts

Posted - 2012-08-02 : 14:14:32

hi,

can any one suggest me the tool or any scripts where i can take the backup or production table (some) replica on my local database.
thanxk

---------------------------

http://codingstuffsbykiran.blogspot.com | http://webdevlopementhelp.blogspot.com

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-08-02 : 14:34:32

export import wizard if you've access to production tables

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

kirank
Yak Posting Veteran

58 Posts

Posted - 2012-08-03 : 03:34:15

Hi, i do have production level access, but i am not able to view the import export option on it, so could you suggest me any other ways to do the same;

---------------------------

http://codingstuffsbykiran.blogspot.com | http://webdevlopementhelp.blogspot.com

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-08-03 : 10:05:20

you should be using export import wizard from dev database. right on database choose tasks->import data to launch export import wizard in dev db

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

kirank
Yak Posting Veteran

58 Posts

Posted - 2012-08-04 : 04:30:56

quote:
Originally posted by visakh16

you should be using export import wizard from dev database. right on database choose tasks->import data to launch export import wizard in dev db

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

hi thnx , but i m not able to view that option on ms sql 2008 whn i take the remote connection of it, i thing this facility has been disable

is there any other way to do so?

---------------------------

http://codingstuffsbykiran.blogspot.com | http://webdevlopementhelp.blogspot.com

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-08-04 : 11:35:28

other way is to use openrowset and use a set of select ... into statements to replicate tables in dev like


SELECT * INTO table1 FROM OPENROWSET('SQLNCLI', 'Server=liveservername;Trusted_Connection=yes;',
     'SELECT *
      FROM Table1') AS a;

...

i doubt whether you'll be able to access OPENROWSET if you cant access export import wizard anyways you can make a try

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

pushp82
Yak Posting Veteran

83 Posts

Posted - 2012-08-05 : 09:56:51

right click on database on production > task>generate script > choose your table with data and copy the script in local and drop old table and fire the script.

You should have sql server 2008 on production.
and there is limit on rows to generate script with data

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2012-08-05 : 11:03:14

SQL Server: Quickest Method to Create Single Table Backup
http://connectsql.blogspot.com/2011/06/sql-server-quickest-method-to-create.html

--------------------------
http://connectsql.blogspot.com/

kirank
Yak Posting Veteran

58 Posts

Posted - 2012-08-07 : 07:07:24

quote:
Originally posted by lionofdezert

SQL Server: Quickest Method to Create Single Table Backup
http://connectsql.blogspot.com/2011/06/sql-server-quickest-method-to-create.html

hi thx for the suggestion, let me try this,

still any one can suggest any other way to do this.
--------------------------
http://connectsql.blogspot.com/

---------------------------

http://codingstuffsbykiran.blogspot.com | http://webdevlopementhelp.blogspot.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources