Category: SQL Server

So I have Database Server running SQL Server 2008 R2, but a lot of Database and Drives on the Windows Server, the request is I want to know each location of Data and Log file on the server, I don’t want to right click and see each one of properties of the DB, so do you right ? Open-mouthed smile

Simple answer is I have to execute this query :

SELECT name, physical_name AS current_file_location
FROM sys.master_files

And the result like the following picture below:



The History of SQL Server

I found nice chronological of how SQL Server come into this world, enjoy! Open-mouthed smile

Yesterday I have to repro cases from OCS, so the point is I have to move OCS DB to another server and I found this link :

I’ve already tried it on my lab and it works, but at my customer I failed so I have to rollback Sad smile.

Here’s the error when I want to Create Enterprise Pool


So after searching the internet and found KB from MS and execute it but still the process won’t go.

With help from DBA and SQL Profiler to trace down what happen, it actually quite simple Smile. The Admin OCS lack of privilege in SQL Backend Server, so MS state when move the OCS DB it needs permission as member of RTCUniversalServerAdmins group, but the answer is it need sysadmin server role in the SQL Backend Server too!

Happy moving! Open-mouthed smile

SQL Server 2012

Have you heard it ? if yes, have you download free E-Book ?

Yes it’s FREE guys Open-mouthed smile Enjoy! This book is for anyone who has  an interest in SQL Server 2012 and wants to understand its capabilities,  including database administrators, application developers, and technical  decision makers.

Here are various versions of the Free eBook.

Blog at
[ Back to top ]