Interview Question

  • 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

  • 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)

  • 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?

  • 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

  • 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.

  • 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