Yes Gila, that code is executed by the developers on 2005... once they use to do it couple of months back..

thats just a given to me so that to implement...

Yes Gila, surely i will read that....:-)

Actually on daily basis many SP get executed so thought of rebuilding the indexes as new records come in it all time...

this was the...

That Means the points mentioned 1, 2 & 3 should be done only???

I want to perform this just as a Good Prectise..

There are 20 Databases almost 10 GB each.. thats it 😉

Gila 🙁

Can you write the steps here with example or query??? i am not able to understand it ckear as i am new in DB activites;-)

Perry Whittle (9/24/2012)

---

I always copy the files then remove the originals when the...

saidapurs (9/24/2012)

---

Hi Gail,

I observed the files are not moved particular path, currently Data & log files are in 'C' drive itself.....

When i executed below query get...

Hello Everyone 🙂

Finally i have been assigned this task to do next month..

but they are still not sure that if i Change the Log File location of the database to...

yes Gila, thats the idea 🙂

I am Gonna Implemenet this probably by next week, just awaiting manager's go ahead:-)

Perry Dont scare me, me doing it for first time:-D

Yes i will note...

Great thank you all... will implement it soon 🙂

Yes i have benn provided a different physical drive...

Well i came to know how to move the Datafile & Log files to different location....

I am just concerned abt TempDB database...

Thanks Perry 🙂

Can you give an example, rough pathfilename etc for this syntax query?

ALTER DATABASE mydb MODIFY FILE(name=logicalname,

FILENAME='new path and drive\the originalfilename.extension')

Also will this approach help in improving perfromance?????????????

Thanks All, will try to make a plan & move 🙂