I am afraid in restoring stage users can’t access database, i would suggest to restore it the time it is minimum used.

Thanks,

DG

First of all please share you backup policy for that server?

cheers!

DG

restore database abc from disk ='backup location'

OR

You can use SSMS also for this task.

it would be unavailable for users till the time it gets restore, time depends on the...

Thanks Steve for your response.

I just wanted to know where i can specify multiple destination servers where i want the unattended installation in ".ini" file. Which i have used(.ini) for...

You can configure alerts for each database as per Steve's link and set them to 80% of your database size. So that will alert you when your database reaches to...

Hi All,

I have gone through this post regarding resource database. I remember once I have tried to regress the service pack by applying old copy of resource database but it...

I also thought about this option but unfortunately logs for that date washed off.

1) Checked logs it didn’t say anything 🙁

2) Already checked backupset as backup didn’t complete no info in backupset

3) I also thought about trace because this is the best option...

Unfortunately this is not a solution I am looking for, I wanted to get rid from it to find out who is doing it and from where. I can get...

Nothing as such installed, application team also have full access on this server, so i doubt if they have done something but i am not 100% sure. Thats why i...

I have already checed all the sql jobs and windows scheduled as well, there is no job scheduled .

about SQL DMO:

Most SQL Server administrative tasks are programmable by SQL-DMO, (DMO)...

Thanks for the response Chirag.

I don’t know where you are getting confuse, anyway let me explain again. I have a scheduled database backup job everyday at 22:30 it works fine...

Sorry to say, but surprised to see....everybody keep saying no....if you agree what’s the need to post reply? We should keep the forum easy readable so that users can see...

Well, it all depends on business requirement. But I would not suggest to erase the previous backups. keep them to some other disks OR on tape (if possible) you never...

Agree with Chirag, the differential backup helps to restore lesser number of log backups. On few of our servers where the backup size is big and we have disk crunch...