Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Default group file is Full
Message
 
À
18/10/2005 05:58:13
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
01059859
Message ID:
01059860
Vues:
12
>Dear Friends,
>
>I Have problem with SQL server-2000 the message come up is "Could not allocate new page for database 'TEMPDB'. There are no more pages available in filegroup DEFAULT. Space can be created by dropping objects, adding additional files, or allowing file growth.."
>
>What should I do, need your help urgently
>
>Thanks
>Hendry Setiawan

Try this.
1. Start Enterprise Manager
2. Open SQL Server and right click on TEMPDB
3. Select properties
4. Go to Data Files tab
5. Check Automaticly grow file and Unrestricted file growth
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform