Being DBA

MCITP

MCITP

Saturday, September 11, 2010

Move TempDB database to new location

ALTER DATABASE tempdb

MODIFY FILE (NAME = tempdev, FILENAME = 'C:\tempdb.mdf');



GO

ALTER DATABASE tempdb

MODIFY FILE (NAME = templog, FILENAME = 'C:\templog.ldf');



GO


Restart the server to take the changes take place.
Posted by Aditya Jha at 11:22 AM 1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

About Me

My photo
Aditya Jha
View my complete profile

Blog Archive

  • ►  2018 (1)
    • ►  February (1)
  • ►  2017 (3)
    • ►  December (1)
    • ►  November (2)
  • ►  2016 (5)
    • ►  June (2)
    • ►  May (3)
  • ►  2015 (13)
    • ►  October (6)
    • ►  July (5)
    • ►  January (2)
  • ►  2014 (8)
    • ►  September (3)
    • ►  April (4)
    • ►  March (1)
  • ►  2013 (3)
    • ►  October (1)
    • ►  September (1)
    • ►  July (1)
  • ►  2012 (5)
    • ►  June (1)
    • ►  May (4)
  • ►  2011 (50)
    • ►  October (1)
    • ►  August (2)
    • ►  July (1)
    • ►  June (4)
    • ►  April (7)
    • ►  March (34)
    • ►  January (1)
  • ▼  2010 (7)
    • ▼  September (1)
      • Move TempDB database to new location
    • ►  July (6)
Simple theme. Powered by Blogger.