How to Prepare POA for TempDB file movement

In this article we will explain how to prepare Plan Of Action(POA) for TempDB file movement.

POA for TempDB file movement
Implementation plan
SL No Steps
1 Take backup of all databases.
2 Take output of Tempdb database.
Use Tempdb
go
sp_helpfile
go
3 Execute the below script to move tempdb files from E drive to T drive
USE master;
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev, FILENAME = ‘T:\Datafiles\tempdb.mdf’);
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = templog, FILENAME = ‘T:\Datafiles\templog.ldf’);
GO
4 Restart SQL Server.
5 Check the database consistency.
Roll Back plan
SL No Steps
1 Execute the below script to move tempdb from T drive to E drive
USE master;
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev, FILENAME = ‘E:\Datafiles\tempdb.mdf’);
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = templog, FILENAME = ‘E:\Datafiles\templog.ldf’);
GO
2 Restart SQL Server.
3 Check the database consistency.

 

POA for Log Shipping Creation

Prerequisites for Configuring Log Shipping

How to Uninstall SQL Server 2012 Instance

Get SQL Dba Tutorial Updates!

Signup now and receive an email once I publish new content.

I agree to have my personal information transfered to MailChimp ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Add Comment