After increasing the log file size the backup job started working normally.

I wondered how the dbcc check db ran with out errors.

Previously when there is no space for the growth,...

Just noticed that log space has restricted growth. Increased the size and run the dbcc check db. No errors found

We have only log backups for some databases no diff backups.

After killing the backup job, took the backup of remaining databases manually (except the db which is blocking). I don't...

So if we can see the spid from sys.dm_execute_requests. i.e. it is active. But I didn't see the diskIO is changing from sp_who2

I don't think I have access to the virtual center database

Yes. I can see the folder and also when I tried to

open VMWareToolboxCmd as mentioned in the link

http://www.virtuallyghetto.com/2011/01/how-to-extract-host-information-from.html

It is nothing doing even not opening cmd

I found it from C:\Program Files\VMware\VMware Tools\open_source_licenses.

I can see this in one server but not able to vmware version in other server.

Thank you all

This should be modified on the server where backup job is scheduled right (Production).

Is there any affects due to this change? It is happening once in a month....

Resourcce Governor is not turned on

After the refresh, I need to map the couple of logins as users.

My main concern is how to identify and restore the last full backup automatically?

When I run the the query

EXEC sp_tables_ex @table_server = 'LinkedServername', @table_catalog='DBName', @table_schema='Test'

I can see all the tables under the test schema

but when I run EXEC sp_tables_ex @table_server =...

This what happened.

We are using the option that Be made using this security Context option.

After the refresh I missed to map the refreshed db to that login. After mapping the...

I am getting some issue with linked servers.

I can see the linked server is created and when I tested it is working fine.

But when I tried to run the select...

I have to map some users and give read permissions in QA env which doesn't exists in the Prod.

I verified the linked server. I tested the connection. Looks they are...