Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement