Viewing 15 posts - 8,251 through 8,265 (of 9,241 total)
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
simply
backup and restore
or
detach and attach
the SQL 7 database to the SQL 2005 server and all the identities should be fine
dont forget to update usages and rebuild indexes afterwards
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2009 at 1:41 pm
what file system is the USB drive formatted with?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2009 at 1:22 pm
Achtang (4/8/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2009 at 8:46 am
Viewing 15 posts - 8,251 through 8,265 (of 9,241 total)