Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Specify location of data files
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
01126868
Message ID:
01126969
Vues:
19
>>I'm creating a new database in SQL2005. In SQL2000 and before, I was able to specify the location of the data files, but it doesn't appear that SQL Management Studio Express allows you to put the files where you want.

>Click on the ellipsis (...) button in the path column of the grid. You can change the data path and log path individually.

Can you be more specific? I don't see an ellipsis, and this is what I was looking for. Again, I'm using SQL 2005. Sounds like you are talking about how to do this in SEM in SQL 2000 and before.

>Why don't you like putting data files in SQL servers space under Program Files?

I don't like co-mingling program files and data. This is hardly a novel idea - I think I first got the idea from one of Whil Hentzen's books, and I agree with the philosophy.
Del
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform