Viewing 15 posts - 3,451 through 3,465 (of 4,745 total)
I would not say huge but it is the MS recommendation and would help.
July 22, 2009 at 8:52 am
vivek (7/22/2009)
July 22, 2009 at 7:11 am
If you block size allocation for the drives, 64K for data files, 8K for log files, block aligned.
July 22, 2009 at 6:37 am
I can confirm you cannot do that.
a) you cannot backup a database in recovery mode
b) even if you could the log restores would fail beacuse they would be missing...
July 22, 2009 at 6:33 am
apply by ensuring all connections to the databases are stopped, backup your databases, then run the installation file and follow instructions. The id you install with shoould ahve admin rights...
July 22, 2009 at 6:13 am
Service Pack 3 has been out for a while now, you would be better off going straight to that.
July 22, 2009 at 6:08 am
Unfortunately if the SQL instance is unresponsive you will not be able to connect (as you have found out) and in SQL 2000 there is no way round this. About...
July 21, 2009 at 3:47 pm
sad thing is I know I will never get the last 5 days back................:-)
July 21, 2009 at 7:11 am
this would be a multi step job and it is warning you one of the intermediate steps failed. expand the job history to see which one.
July 21, 2009 at 7:09 am
what wait types do you see when this happens? This could point you in the direction of where the bottlleneck is.
sounds ums scheduler related so would be a good idea...
July 21, 2009 at 6:53 am
Only the INactive part of the log is truncated, the active part, i.e transactions that are not commited yet or in the case of replication not passed to the distribution...
July 20, 2009 at 12:14 pm
there is a number of ways of varying complexity, linked server, opendatasource, powershell scripts.
For this I think I would go for a .bat file running a number of osql commands,...
July 20, 2009 at 9:15 am
to show server configuration
exec sp_configure 'show advanced options', 1
reconfigure
exec sp_configure
exec sp_configure 'show advanced options', 0
reconfigure
not sure what else they could want but you also send the latest errorlog and\or run...
July 20, 2009 at 7:12 am
Raju Lalvani (7/20/2009)
Most of the people take Certification exams because it makes their resume appear better.
well obviously.
They do not take it to increase their knowledge or hone their technical...
July 20, 2009 at 6:56 am
Viewing 15 posts - 3,451 through 3,465 (of 4,745 total)