Hi,

If you had lost the 11am backup file then you can restore point in time upto 10am only. There is no way that you can restore up...

Hey,

If you do that then that will be the last day of your job because reconfiguring the replication requires generation of new snapshot and if the...

I think there's a confusion. I got a full backup of a db from another team and I had restored onto one of my servers. After restoration space on one...

Thanks for the reply. I have one more problem I have another db which is in full recovery model and in the shrink file dialog Currently alloted space is 57049.19...

Make sure that you have enough free space for the transaction logs and keep monitoring for a few days on the transaction log size and the required frequency of taking...

Hi,

Earlier it was a standalone server and now the client wants it as a clustered one. So we had detached the db's and created the cluster environment...

Oh I feel sorry for that guy. But I surprise how the database can be deleted when it is in use. most of the production db's will be continuously in...

No unless you have any version control system as told by Steve

Hi,

Mostly by roles. But for some users they were given individually. Can you give me the script to this or any tool.

Thanks

Chandra Mohan N

Hi,

There may be many reasons why the sqlserver was not connecting.Check the following.

1. Check whether you are able to connect locally in the machine where sql 2005...

Hi,

I think its not a bug. Generally some of the updates requires the sql services to be stopped to apply. So this patch first stops the sql...

Hi,

I had found out the root cause and resolved the issue. One our distribution box which is crucial to the business was getting shutdown everyday at morning 5.00am....

Hi,

Yes me too faced the same problem. One our distribution box which is crucial to the business was getting shutdown everyday at morning 5.00am. We had run the...

Hi,

Thanks for the reply. Can you tell me how do i find whether this is causing the services to stop or any other. Iam confused where to start...

Just windows and sql server 2005 ent ed with sp2