Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to disable a database temporarily
Message
De
18/02/2009 13:01:44
 
 
À
18/02/2009 12:55:16
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 7.0
Divers
Thread ID:
01382686
Message ID:
01382691
Vues:
63
This message has been marked as the solution to the initial question of the thread.
>I have about 100 SQL Server 7 databases that I am trying to migrate to 2005. What I would like to do is disable the old database after I think it's completely migrated, just in case I miss something. What's the easiest way of doing this? I know I can mess with the user's permissions, but some of the permissions are somewhat elaborate and I don't want to have to remember them weeks from now. Plus, there can be more than one user set up in a database.
>
>I'm sure it has something to do with setting an explicit "deny" permission on something. Emphasis on easy disable and easy re-enable. Thanks!

You can take offline or detach

http://blog.sqlauthority.com/2007/04/25/sql-server-2005-take-off-line-or-detach-database/
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform