Detach System Database Files!!

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Detach System Database Files!!

Author

Topic

Kleber
Yak Posting Veteran

67 Posts

Posted - 2004-04-16 : 10:00:01

Hi all

Once again, I found something that makes me nervous. Someone (A.K.A. The old DBA that didn't makes any backup) He created a new database physical file to TEMPDB on a EMC hard disc. Now, i need to move this disc to another server, and, I know i can't detach TEMPDB and move it to another location. So, I ask... How can I do it without kill that DBA @#$%#?

Regards
Kleber
Brazil

surefooted
Posting Yak Master

188 Posts

Posted - 2004-04-16 : 10:06:30

You cannot detach TempDB. To Move Tempdb:

use master
go
Alter database tempdb modify file (name = tempdev, filename = 'E:\Sqldata\tempdb.mdf')
go
Alter database tempdb modify file (name = templog, filename = 'E:\Sqldata\templog.ldf')
go

look at this article for future reference.

http://support.microsoft.com/default.aspx?scid=kb;en-us;224071&Product=sql2k

-Jon
Just a starting member.

Kleber
Yak Posting Veteran

67 Posts

Posted - 2004-04-16 : 10:25:42

Well
It works fine, Thank you very much.
And be sure that this article are on my favorites now.

Thank you again
Kleber
Brazil

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources