Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server question.
Message
De
19/04/1999 21:10:30
 
 
À
19/04/1999 08:53:36
Mark Hall
Independent Developer & Voip Specialist
Keston, Kent, Royaume Uni
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00208903
Message ID:
00209981
Vues:
18
>I think one of the main lessons here is :
>
>When data and log reside together,
>The developer is in for heavy weather!

It really isn't a good idea. By combining the data and log segments your administrative tasks become extremely difficult. The only other thing that I could recommend is checking to see what segment SQL Server allocated the extra 300MB. Try running sp_helpdb database_name. You'll get a list of the allocations and what segment they belong to. My guess is that the 300MB has been allocated to data. If memory serves me correct you have to extend the log to a new device. Man it's been a long time since I've taught a SQL 6.5 course.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform