Hi Roshan,

Now, secondary Server is running fine, as I made it's database online. As our Primary Server is up and running now, I would like to make this Server as...

Hi,

Not sure whether your comment questioned or tried to help me out in this regard... 🙂 We do not have core DBAs and in general, we handle by our own....

Performed manual Full backup of a DB and when trying to take manual Diff. backup, same error appeared...

Msg 3035, Level 16, State 1, Line 1

Cannot perform a differential backup for...

Table shwoing all the Databases are fully backed up and recent date was Today's. After this Full backup also, I tried to run Diff. job, but no luck with same...

No DBs were created recently. If yes, it should be included when I ran Full backup job successfully.

Thank you for the reply...

I already got the info. through 'dm_db_index_usage_stats' & it displayed only Last_Read & Last_Write dates of all the DBs. But we can't get the exact details...

Hi,

If frequently DML operations applied on the DB (Insert, Update & Delete), the Log will grow as per the transactions. So whenever any Delete operations applied on the DB, the...

Hi Amit,

If you don't mind, could you please elaborate the issue which you are experiencing wit Replication?

Hi,

Here we are migrating the complete Server from one version to another version .i.e. one Physical or Virtual Server to another Physical or Virtual Server. So the Server name will...

Hi,

If you manage Windows Level Security though Active Directory, you can provide him "Local Admin (LA)" permission on that Server to the person, if you wish to.

or else

you can only...

Hi,

You can try to configure the Linked Server with alias name. This alias name will be given, when the two Servers are in Different Domain.

Please try to set up to...

It doesn't have any State no., just given the Error msg and moreover, I can't see Error Logs from SSMS through any SQL Server Login, because those have only Read...

Yes Salum,

Thats is what I've mentioned above. I've tried with all the roles from MSDB, but still unable to Modify the jobs. Could you pelase suggest how I can manage...