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.
| Author |
Topic |
|
zhshqzyc
Posting Yak Master
240 Posts |
 Posted - 2012-01-30 : 09:31:45
|
| Hello, I am new to a new company. There are many databases. Each of them may sit on the different windows servers. There are a lot of windows server 2003 and 2008 in the company.My question is that how can I quickly be familar with the databases distribution on different physical location?In other words, suppose I found there are databases such as db1, db2, db3,....when I open Microsoft SQL Server Management Studio 2008.And I also found that there are servers on the network \\n1, \\n2, \\n3....Maybe db1 is on the server \\n5 but I really don't know, ask people is possible but a little stupid.Thanks. |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-01-30 : 10:54:42
|
| When you open SSMS if you are seeing the databases, doesn't mean that you are already connected to the servers? If that is so, you should be able to look in the object explorer and see which server the database is on.Or may be I am completely misunderstanding what you are asking? |
 |
|
|
zhshqzyc
Posting Yak Master
240 Posts |
Posted - 2012-01-30 : 11:21:39
|
| Yes. You misunderstood it. Suppose db1.mdf is on the server \\n1\Data\db1.mdf, db2.mdf is at \\n5\Data\Somefolder\db2.mdf etc. But how can I know it? sys.server?sys.database_files.physical_name? |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2012-01-30 : 18:04:10
|
| select name,filename from sysaltfilesfrom this output you can guess which belongs to which db. |
|
|
|
|
|
|
Find instance location on the network