Viewing 15 posts - 8,251 through 8,265 (of 9,244 total)
yes, it wasnt until i tested it and was able to confirm it works that i now plug it into my DR processes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2009 at 5:57 pm
the other trick to recover from a dead master database is to take a backup of the master and restore it to a different sql instance as another name (i.e....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2009 at 5:04 pm
do you really need to log ship all 16 databases??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2009 at 4:26 pm
No George, the whole point is this
your master database is corrupt, you cant start sql to restore the database. You dont want to rebuild or you cant cos you dont...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2009 at 4:05 pm
larry Hennig (3/13/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2009 at 1:28 pm
you're not alone, i was sure the c2 audit wrote trace files to the LOG folder as well as the default trace, shows how wrong you can be. Then, i...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2009 at 6:55 am
this details it
http://msdn.microsoft.com/en-us/library/aa196700.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2009 at 6:03 am
your welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2009 at 2:53 pm
mldetch (4/8/2009)
I receive an error message stating the 'common criteria compliance enabled' does not exist or it may be an advanced option.'
it doesnt exist as you are not running sql...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2009 at 2:48 pm
no as Lynn pointed out id 2 is the default trace
what version of sql server is this as common criteria is only available in dev or Ent sql editions
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2009 at 2:41 pm
so it sounds like it is common criteria, did you run the code Jack posted above?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2009 at 2:39 pm
this is not a default trace as that logs to the LOG directory not the data directory
stop and close the trace as i specified, then go hunt down how this...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2009 at 2:33 pm
from this
1 1 6
1 2 \\?\C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\audittrace20090407090827_200.trc
1 3 200
1 4 NULL
1 5 1
traceid 1 is your culprit and this "1 5 1" means its still running. Try stopping...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2009 at 2:21 pm
FAT32 does not support file sizes of over 4GB (4294967296 bytes - 1), also your partition size is capped @ 32GB.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2009 at 2:10 pm
google found this, it gives you uptime of sql instance in minutes
SELECT datediff(mi, login_time, getdate())
FROM master..sysprocesses WHERE spid = 1
alternatively for server uptime try this[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2009 at 1:51 pm
Viewing 15 posts - 8,251 through 8,265 (of 9,244 total)