Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fgilain
Starting Member
5 Posts |
 Posted - 2003-12-03 : 04:57:21
|
| Hi all,I run windows 2000 Server with SQL Server 2000 enterprise.Here is my problem :I often have a problem with my free disk space available on c:\ because of a file called my_db.LDF (1.5Go minimum) in c:\program files\Microsoft SQL Server\MSSQL\DATA\ that was growing a lot sometimes...I decided to add a new hard disk, which is now E:\ where I wanted to move that file in order to leave it growing as big as it wants.NB : there is too a *.MDF file with the same name here too...maybe should i move that too)But i'm unable to do it.Can someone help me on it please, i'm really new to MS SQL SERVER...Thanks a lotFlorent |
|
|
fgilain
Starting Member
5 Posts |
Posted - 2003-12-03 : 05:23:04
|
| Hi all,I just tryed to use the explanations found here http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071but now, i'm unable to connect to my MS SQL SERVER using EM, here is the error message i get (translated from french) :Unable to open default's user database.Connexion failed.Thanks for your help, this server is a production server...Florent |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-03 : 12:19:12
|
| Connect using a local windows admin account. Then go to the userid that is having the problem and change the default database. Then try connecting with that account.Tara |
|
|
|
|
|
|
moving *.LDF file ?