Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12345»»»

Changing Locations of DataFile Expand / Collapse
Author
Message
Posted Tuesday, September 18, 2012 3:30 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
Great thank you all... will implement it soon







************************************
Every Dog has a Tail !!!!!
Post #1360644
Posted Tuesday, September 18, 2012 4:20 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:29 AM
Points: 6,318, Visits: 13,621
great, just make sure to pay attention to what you're doing and it will be fine

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1360662
Posted Tuesday, September 18, 2012 4:22 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
Perry Whittle (9/18/2012)
great, just make sure to pay attention to what you're doing and it will be fine

Perry Dont scare me, me doing it for first time
Yes i will note down each step i do








************************************
Every Dog has a Tail !!!!!
Post #1360665
Posted Tuesday, September 18, 2012 5:18 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:29 AM
Points: 6,318, Visits: 13,621
when are you doing this?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1360692
Posted Tuesday, September 18, 2012 5:35 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
Perry Whittle (9/18/2012)
when are you doing this?


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








************************************
Every Dog has a Tail !!!!!
Post #1360700
Posted Tuesday, September 18, 2012 5:55 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 42,844, Visits: 35,972
Try it out in a test/dev environment first. Even if it's just your local machine.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1360715
Posted Tuesday, September 18, 2012 5:57 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
GilaMonster (9/18/2012)
Try it out in a test/dev environment first. Even if it's just your local machine.


yes Gila, thats the idea








************************************
Every Dog has a Tail !!!!!
Post #1360718
Posted Monday, September 24, 2012 3:24 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
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 other drive & also if i change the Tempdb log file location to other drive will it help improving performance???

I have no answer as of now..








************************************
Every Dog has a Tail !!!!!
Post #1363379
Posted Monday, September 24, 2012 4:00 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 42,844, Visits: 35,972
It might. It might not. Depends on the current bottlenecks, the drive architecture and a whole lot of other factors.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1363395
Posted Monday, September 24, 2012 4:05 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 8:06 AM
Points: 167, Visits: 414
Hi Peery & Gila,

I test it in my local server getting error while executing below query

Query :-
ALTER DATABASE Test MODIFY FILE(name=Test_data,
FILENAME='D:\Test\Data\Test.mdf')


Error :- MODIFY FILE failed. File 'Test_data' does not exist.

But log file is moved successfully...

Please let me know where i did mistake.

Thanks & Regards
Satish Saidapur
Post #1363397
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse