You are right that i need to add space or drive but still I am not much clear that after restarting why it's not clearing the space as Tempdb is...

Thanks.

I have concern as I am almost close to full capacity and somehow it's not still clearing the space and I couldn't see any open active transaction.

Could you please guide...

That's correct as my TEMPDB drive is 5 GB.

Hi,

When I was looking on server drive after restarting, it is showing on folder - Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data is 4.97 GB and when I right click on drive it...

Thanks.

Only my concern is that it might cause corruption, right?

Thanks, I will check it out.

Thanks, I need to check that one, Are you taking T-Log Backup daily for MSDB or System DB?

Thanks.

I tried using SSMS and T-sql and logged as administrator and assigned also access to everyone full control but didn't work.

Thanks, I will check the link.

Thanks Yelena.

We haven't set up yet but planning to set up frequently T-Log Back up.

We have currently 300 GB Data.

Due to Replication running, Data is keep Changing.

Rightn ow it's in...

Thanks Erland.

Actually, I am asking to upgrade from sql 2008R2 evaluation to actual licensed product and want to make sure that it's just simple upgrade no DB restore or down...

Thanks for your resposne.

Default DB is MASTER.

DB is ONLINE

it's in MULTI_USER Mode

I don't have any User DBs, only System DB

Thanks.

Thanks Alan.

Right, I am talking about Subscriber DB.

If we get from the another subscription then it will be fine.

If we get the new subscription then we have to do...

Any help, please?

Thanks.

Thanks once again!

I am laready Monitoring Activity Monitor and but lots of job is mainly coming from Replicated DB.

Couple of job i have troubleshoot from other source job and improved...