Viewing 15 posts - 31 through 45 (of 160 total)
Perfect.
Thanks Derrick.
October 25, 2010 at 11:29 am
The addserver command did not work: "The server xxxx already exists"
Which is true. The new server name has been recognized by SQL Server and the jobs, procs, mirroring,...
August 25, 2010 at 2:42 pm
Thanks Wayne and Derrick
I'll give that a try.
Elliott
August 25, 2010 at 2:36 pm
Gail,
It appears to be an OS error:
An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown
(This was from a query to select from a large...
August 23, 2010 at 2:28 pm
Create Table AsciiChars(Acode int, C Char(1))
Declare @cmd varchar(200)
Declare @code smallint
Set @code=32
WHILE @code<127
BEGIN
Set @cmd='
Insert into AsciiChars
Select + CAST(' + @code + ' as varchar(3)), CHAR(' + CAST(@code as varchar(3)) +...
August 23, 2010 at 11:52 am
steve,
Excellent points. DR is my number one priority for this firm (and I should have mentioned that we have Enterprise Edition). I maintain a group of DR stored...
June 10, 2010 at 11:11 am
Steve
I was thinking that if I had an archive table on an archive filegroup, I could back up that filegroup fairly infrequently (and keep multiple backups in multiple locations for...
June 10, 2010 at 10:56 am
Thanks for the filegroup idea.
In your concept, would I need to periodically (quarterly) create new filegroups to hold (new) archive tables, or could the archive table and filegroup just be...
June 10, 2010 at 9:49 am
No, I didn't get any suggestions on where to look. I still believe that it is a network connectivity problem, not a SQL Server problem. The problem is...
April 28, 2010 at 5:35 pm
Depending on your activity level, it may simply be taking a while to re-synchronize. How long did you allow the command to run?
March 19, 2010 at 9:34 am
Thanks for the explicit explanation Gail. I did not realize that read_only would affect not just the user objects, but the database header. The behavior of both the...
March 19, 2010 at 9:27 am
GTR: Thanks for responding. The first thing I did was to take a full database backup and then attempt to backup the lob (see first post). Of...
March 18, 2010 at 12:53 pm
Thanks for the method. I'm still surprised that being in a read_only state would preclude backing up the log.
Elliott
March 17, 2010 at 5:00 pm
Lowell: Yes, that's exactly what I was trying to do. According to Systems, Veritas BE will need to have a seperate backup job for the "Simple" database, while...
March 17, 2010 at 2:43 pm
Viewing 15 posts - 31 through 45 (of 160 total)