You can take full backup on primary anytime but if you restoring the log backup in...

1) is database mail enabled?

2) if yes, then have you configured any profile to send mail?

3) if yes, then are you able to send test mail by that profile?

for this....you can configure the threshold limit for sql files and similarly threshould for physical drive OS counters which will generate the alerts/message as soon threshold limit is about to...

we use litespeed...spotlight and PA(Performance Analysis)

edit :-

spotlight for live monitoring

PA for analysis of past.

if you mon and year is int then :-

select convert(varchar(20),monvalue)+'/'+ convert(varchar(20),year) as datewise, ans from yourtable

And if mon and year are varchar then :-

select monvalue +'/'+ year as datewise, ans...

I no where said that job is created with same account. What I said was same job...

ii) i have a job which is running under a disabled windows account and still the job runs fine. How is this possible? The job owner is a disabled account,...

are you sure your database is online? How are you taking your...

if your database is accessible and healthy then instead of taking the backup to problamatic location, you can take it to some other location( other drive).

OR

are you saying that...

how big is your database? Do you have enough space on the disk where you putting the backup file if not then you need to amend the location as :-

backup...

is the location exist which is mentioned for backup? Seems like the path is no more accessible.

Also not sure what do you mean by recover the backup?

as long...

In addition to above, to check the permission for a perticular user, you can use sp_helprotect.

For Ex. :-

exec sp_helprotect @username='test'

01. Not able to restore if the structure of the drives are different. If my primary db is on D and F drives, while restoring the same database on different...

do you really need full backup or differential backup can be considered?

i would like to see :-

1) If the query is using select * or select required columns

2) any filter condition (like where) is uisng the proper candidate for filter...