Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Restore database slow
Message
De
09/09/2002 21:53:01
 
 
À
09/09/2002 10:17:46
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Divers
Thread ID:
00697240
Message ID:
00698597
Vues:
14
>We can't change hardware now.
>Do we have other way to make retore faster.
>If we can change SQL configure or options of restore command and make restore faster?
>
>
>Thanks
>
>
>Jim

MORE MEMORY! This will speed up almost every aspect of SQL.

Also, make sure you are using the best recovery model for your use of SQL server and your backup schedule.

Have you tried to dettach the database, make a copy of the file, then reattach the database? This of course is similar to simple recovery mode, but it does allow you less downtime and you can back up the copy of the database to a tap while the server is up and running.

BOb
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform