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
like it!
---------------------------------------------------------------------
July 22, 2009 at 5:59 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)