Move DB and Log File Q - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Administration

Move DB and Log File Q

Author

Topic

Grifter
Constraint Violating Yak Guru

274 Posts

Posted - 2011-11-02 : 06:18:47

Hi

I followed the instructions here

http://msdn.microsoft.com/en-us/library/ms345408.aspx

to move the adventureworks DB from my desktop to my DB directory . Everything worked ok and the location of the DB now shows as where I moved it but when I go to the directory the DB and log file is not there?

When I run:

SELECT name, physical_name AS CurrentLocation
FROM sys.master_files
WHERE database_id = DB_ID(N'AdventureWorksLT2008');
GO

It shows the directory where I wanted to move DB/Log but it is not there.

Thanks

G

Grifter
Constraint Violating Yak Guru

274 Posts

Posted - 2011-11-02 : 06:40:01

I've Io

Grifter
Constraint Violating Yak Guru

274 Posts

Posted - 2011-11-02 : 06:40:52

I've also noticed that only the database name is there in the list of DBs but no menu to show any objects in the database.

G

Grifter
Constraint Violating Yak Guru

274 Posts

Posted - 2011-11-02 : 07:10:25

Reboot fixed this and can see DB now.

G

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources