Results 1 to 6 of 6
  1. #1
    Member
    Join Date
    Nov 2010
    Location
    Belgium
    Posts
    80
    Thanks
    22
    Thanked 0 Times in 0 Posts

    Default How to overwrite a database with a restore without manually changing DB state?

    TSM Server 6.2.2.0 | TSM Clients 6.2.2.0 | TDP MS SQL 5.5.4.2

    Dear,

    Is there a way to restore over an existing database without first having to set the database to "single user mode" in the MS SQL Server Management Studio? By changing the state of the database, all users get disconnected and the database can be overwritten.

    I can restore a DB to another location, but I can't figure out how to overwrite a database with a restore without first having to change the state of the database manually. Shouldn't the TDP do that for me?

    Thanks for your help!
    Current Infrastructure:
    TSM Server 7.1 running on Linux Suse 11 SP2 - TSM Clients all running 6.2.2.0 or better - TDPs at latest version.

  2. #2
    Member zsoltesz's Avatar
    Join Date
    Feb 2008
    Location
    Hungary
    Posts
    105
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Default

    Or, before the restore you can kill the sessions that connected to the database.

  3. #3
    Member
    Join Date
    Nov 2010
    Location
    Belgium
    Posts
    80
    Thanks
    22
    Thanked 0 Times in 0 Posts

    Default

    Hi,

    Thanks for your answer. Putting the DB in single user mode does in effect, kill all connections to the DB. I was just wondering why the TDP does not do this? Are you saying that before restoring a DB one should manually kill all connections to it from the SQL Manager?
    Current Infrastructure:
    TSM Server 7.1 running on Linux Suse 11 SP2 - TSM Clients all running 6.2.2.0 or better - TDPs at latest version.

  4. #4
    Member
    Join Date
    Nov 2010
    Location
    Belgium
    Posts
    80
    Thanks
    22
    Thanked 0 Times in 0 Posts

    Default

    Could someone confirm this for me? Do I really have to manually kill all connections to the DB before overwriting it? The TDP will not do this even though there is an option to overwrite?

    Any feedback is welcome!
    Current Infrastructure:
    TSM Server 7.1 running on Linux Suse 11 SP2 - TSM Clients all running 6.2.2.0 or better - TDPs at latest version.

  5. #5
    Newcomer
    Join Date
    Nov 2009
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    I also have to kill connections to the DB with the SQL management studio when restoring over an existing database, Otherwise restore fails with database in use.
    I doubt the TDP does this.

  6. #6
    Newcomer
    Join Date
    Oct 2011
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Quote Originally Posted by foobar2devnull View Post
    TSM Server 6.2.2.0 | TSM Clients 6.2.2.0 | TDP MS SQL 5.5.4.2

    Dear,

    Is there a way to restore over an existing database without first having to set the database to "single user mode" in the MS SQL Server Management Studio? By changing the state of the database, all users get disconnected and the database can be overwritten.

    I can restore a DB to another location, but I can't figure out how to overwrite a database with a restore without first having to change the state of the database manually. Shouldn't the TDP do that for me?

    Thanks for your help!
    I am wondering this myself. Does anyone know? Do I really have to change the state of the database manually? If someone can help me figure this out I would really appreciate it. I really need to restore a database for a payroll utility that I am developing. Thank you very much.
    Last edited by Tyrese; 10-30-2011 at 12:18 PM.

Similar Threads

  1. Is there a way to completely overwrite a tape ?
    By egtegt in forum TSM Operation
    Replies: 3
    Last Post: 03-16-2009, 07:47 AM
  2. DB Backup Overwrite / Retention
    By DHall in forum Disaster Recovery Module
    Replies: 19
    Last Post: 02-04-2009, 10:08 AM
  3. System State Restore
    By chalkd in forum Restore / Recovery Discussion
    Replies: 4
    Last Post: 09-20-2007, 12:47 PM
  4. System State Restore
    By chalkd in forum Restore / Recovery Discussion
    Replies: 1
    Last Post: 09-18-2007, 04:09 PM
  5. System State Restore
    By chalkd in forum Restore / Recovery Discussion
    Replies: 2
    Last Post: 07-24-2007, 06:06 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •