Viewing 15 posts - 376 through 390 (of 2,840 total)
Since the topic is Back up, I thought I would ask a stupid question. If you do a back up to local disk, you will see that there is a...
-Roy
August 26, 2011 at 11:27 am
great read. I just send the link to the management team.. 😀
-Roy
August 26, 2011 at 9:24 am
I am not sure I understand the logic of what you are doing. From what I can grasp from your post, you are going to use Server IN work just...
-Roy
August 26, 2011 at 9:17 am
Only thing I would point out in this case is if you have log file in the drive of the OS and for some reason the log file grows too...
-Roy
August 26, 2011 at 9:02 am
TBH, I am not sure if that can be done. I have not tried it. We have had our DB Server go down for an hour because of MSDB corruption....
-Roy
August 26, 2011 at 8:21 am
There are couple of gotchas in replication when failing over to secondary and failing back to primary.
1. You have to use KEEP_REPLICATION option when restoring log.
2. You might...
-Roy
August 26, 2011 at 7:41 am
What kind of replication are you setting up? Did you try reading some articles on how to set up articles. Please give more details on what you are trying to...
-Roy
August 26, 2011 at 7:31 am
Does it say it is getting unloaded due to memory pressure? You are running into memory issues.
-Roy
August 26, 2011 at 7:16 am
I think you can use Policy based management to make sure that it does not happen again. I have never tried it.
-Roy
August 25, 2011 at 2:10 pm
If my memory serves me right DBCC CheckDb uses memory. Quite a bit of it. For all data pages that need to checked, it has to move it memory. TempDB...
-Roy
August 25, 2011 at 2:06 pm
You can telnet from your SQL Server to Linux on port 1433 and not the other way round? Then it could be that the firewall is not configured properly.
-Roy
August 25, 2011 at 12:33 pm
I have only one advice, make sure to take a back up and copy it into a share before you do anything. There are always "What If" scenarios.
If I...
-Roy
August 25, 2011 at 12:31 pm
I was trying my level best to hit 3K posts before the THREAD hits 30K. Till yesterday evening I was doing good. From yesterday evening to till now, the Thread...
-Roy
August 25, 2011 at 11:27 am
I was talking about it will be fun to work on the committee. Not piss people off.
-Roy
August 24, 2011 at 12:42 pm
LOL... The name Roy Ernest and nominated for pass board does not go together. 🙂
We will just do reviews on the applicants for board members. I hope we do...
-Roy
August 24, 2011 at 12:19 pm
Viewing 15 posts - 376 through 390 (of 2,840 total)