September 22, 2010 at 5:51 am
Another way is using SQLCMD.
btw The solutions you are looking for in this thread are actually only exporting / importing data.
It takes more to be considered a solid backup strategy !
Native sqlserver database backups contain way more info than just the data.
The problem you only want to restore / load a single table, doesn't come with the default microsoft tool set, but there are companies that offer that kind of solutions.
(e.g. red gate SQL Object Level Recovery Pro / Quest LiteSpeed / ...)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 22, 2010 at 6:28 am
Exports In SQL Server
I agree and I have found a script using SQLCMD to output all user table data from a SQL Server database into text files. Now, as for a backup and restore of a user table in a SQL Server database, I have a small development database (20 GB - consisting of 150 user tables) and users/developers ask me all of the time to restore data from one of more tables (usually 1-5 tables). I find it rather easy (in addition to nightly backups) to run an SSIS export/import package of only user tables. This make restoring of these tables very easy and quicker. I only use this SSIS export/import package for this one database.
Also, you are correct about other vendors have the solution to my section's stated task. However, as everyone knows, and I (management), at the current time, do not have any money to spent on "third party tools"! At least, that's what I am being told!
Thanks for the info! have a great day!
September 22, 2010 at 6:40 am
... dev data ...
If you are using a sql server developer edition (2005/2008) have a look a database snapshots as they may come in handy to retain "the morning image" of your dbs content.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 22, 2010 at 6:57 am
Exports In SQL Server
I am running SQL Server 2005, Service Pack 3, Enterprise Edition. Thanks for the info about Snapshots! Have a great day!
September 22, 2010 at 6:59 am
Enterprise edition on a dev server? That's going to really hurt the licensing budget. (Enterprise has to be licensed (;processor or CAL) regardless of how it is used)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2010 at 7:59 am
Exports In SQL Server
To Gail Shaw,
Don't cut me short! hehe. We have 3 SQL Server 2005 environments (development, test, and production). All of them are using SQL Server 2005, Service Pack3, Enterprise Edition. Money was great back then! And, besides, mixing and matching in our environment is not allowed! hehe.
September 22, 2010 at 8:03 am
Developer edition is feature-equivalent to Enterprise edition at a fraction of the cost and with a non-production license.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2010 at 12:06 am
Oh yes, Dev Edtn vs Ent Edtn in licensing terms will vary more than a decent hardwares cost.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 8 posts - 16 through 23 (of 23 total)
You must be logged in to reply to this topic. Login to reply