Hi,

my bed.....

the db is not online. still

when i run ALTER DATABASE DBNAME SET ONLINE command, i get the following result:-

Msg 5120, Level 16, State 101, Line 1

Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\dbname.mdf"....

RECOVERY_PENDING

@ jay holovacs,

I share the same sentiments with you. For i am busy with VMWare as part of my DBA and one i finished VMWare, i will engage in HyperV...

@ SSC Veteran, Well said.

Hence it's not all that bad to be a jack of all trades, but you still have to be a master of something.

Most Technical people do not have soft skills and dealing with people's personal problems isnt their thing, they would rather deal with machines and error codes.

Hi Steve,

I as a SQL DBA would like to shift my career to a Virtualization path but still having to work on Db VM servers.

Why if you may ask?

Well...

Your can also grant read write permissions only, that is if they will not be tampaering with the DDL but working on DML.

Can i have the same setup with developer eddition?

SQL 2008 come with query execution plan and estimation. try testing this queries and see the estimated results.

Well if those Databases are not involved in Clustering but running on a Normal Db Server which is a VM, then it's fine because you can have Thin provisioning and...

Ever thought of the Query Analyzer?

the first option is best.

Hi,

i don't know where you are located or where your business is located and what your organization's area of specialty is. But to cut the long story short, SQL Azure...

Yeah, i as a DBA dont receommend Virtualization on SQL unless it's a low risk Database server with few Transactions.

However if that be the case, go for the Veterens called...

VMWARE AND HYPER V offer the same sentiments, however from my opinion i would go for the veterens of Virtualization which is VMWARE, i have been working on VMWARE for...