December 1, 2006 at 10:55 am
Please answer these questions for me.
Can only one "Table" be backed up? If yes the then how and how do you restore it if needed.
How do you detect Deadlock and what are some of the ways to resolve deadlocks.
Answers will be appreciated and helpful to alot.
Thanks
Ta
Tajammal Butt
December 1, 2006 at 11:00 am
Before SQL 7, there is a simple approach to backup a table. After SQL 7, we need to put a table into a filegroup, and then we can backup and restore a table.
To detect a deadlock, we may either look the sysprocesses table, or turn on TRACEON(1204)
December 1, 2006 at 1:14 pm
You could technically use DTS to export the data out of a table to CVS file or anything you can imagine. That wouldn't export the schema, though. Is there a way to backup the schema through scripting? Something like you get when you generate a create script for an object in Query Analyzer?
December 1, 2006 at 1:29 pm
Yes, there is a way to create a schema and save that...and you can basically do for all database objects..
Right click on DB from enterprise manager. click on "all tasks" and then "generate sql scripts".
Pick up ur options and Bingo....
Tajammal Butt
December 4, 2006 at 8:12 am
My question is more about if its possible to get the schema and save it via t-sql or DTS. You can't easily automate generating scripts from enterprise manager or query analyzer. If you could do that, then you could effectively create a table level backup, which seemed to be what your original question was about.
January 25, 2007 at 1:18 am
it is not possible .
u can do this same work with other technique
u can do this with the help of dts.....
as other's said in the previous post.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply