I see..Hmm how do I trace it then ?

cheers

WhiteLotus (5/1/2015)

---

Grant Fritchey (5/1/2015)

---

ZZartin (5/1/2015)

---

WhiteLotus (5/1/2015)

---

Grant Fritchey (5/1/2015)

---

WhiteLotus (5/1/2015)

---

Grant Fritchey (5/1/2015)

---

3gb is teeny tiny as databases go. Since you're at 99% usage on the data, I'd suggest moving this to...

Grant Fritchey (5/1/2015)

---

ZZartin (5/1/2015)

---

WhiteLotus (5/1/2015)

---

Grant Fritchey (5/1/2015)

---

WhiteLotus (5/1/2015)

---

Grant Fritchey (5/1/2015)

---

3gb is teeny tiny as databases go. Since you're at 99% usage on the data, I'd suggest moving this to a...

Grant Fritchey (5/1/2015)

---

WhiteLotus (5/1/2015)

---

Grant Fritchey (5/1/2015)

---

3gb is teeny tiny as databases go. Since you're at 99% usage on the data, I'd suggest moving this to a larger drive so you...

Greatt...

Ohh nicee thx ..now i am thinking to expand it into 5GB . What do u think ?

I want to make clear here .. it is not disk space problem but the problem is data file is too big for some user databases . One of databases...

Grant Fritchey (5/1/2015)

---

3gb is teeny tiny as databases go. Since you're at 99% usage on the data, I'd suggest moving this to a larger drive so you can have it...

Eirikur Eiriksson (4/30/2015)

---

No, you cannot reduce the size of this file without either purging data or compacting/compressing...

Koen Verbeeck (4/30/2015)

---

WhiteLotus (4/30/2015)

---

Hmm let me think about it 🙂

Btw do you know how to reduce data file ? I know how to reduce trans log file ( by doing...

Thanks for the reply ... appreciate !

cheers mate

Hmm let me think about it 🙂

Btw do you know how to reduce data file ? I know how to reduce trans log file ( by doing Backup trans log...

Thanks for the reply 🙂

Actually What I am worried is about someone created new database someday without my knowledge and he doesnt understand about recovery model ... Thats will be...

Much appreciate on your reply !

Honestly I am still not sure about “creating a synonym in master that points to the new location.” Would you please explain in more detail...

Thanks for the reply !

1.OK . I will try to backup the transaction log

2.Hmm Do you mean everytime I create a new database it will automatically set to SIMPLE Recovery...