Viewing 15 posts - 286 through 300 (of 366 total)
When the database is in restoring state, it means the databases is not online/unavailable- Hence not accessible. so, it would not be possible to take a backup of that database...
November 3, 2009 at 1:34 am
Hi,
I'm running Update stats Maintenance task job weekly and its taking 1 hr 15 mins and I'm not sure whether Update stats job required to run on production instance. As...
November 3, 2009 at 1:27 am
thanks Krishna,
My question is: Is there any way to take the backup of a database, which is in restoring mode?
November 3, 2009 at 12:25 am
Mydb1 is the biggest database of size 30GB and I’m using Maintenance plan Rebuild index task to rebuild indexes for all database on every Sunday.
I have the Log shipping...
November 2, 2009 at 5:15 pm
Is your log backup frequency also hourly? I would hazard a guess it is and because the log file is big due to the reindex it has taken a little...
November 2, 2009 at 4:50 pm
Steve,
I have ran the below query in my Server and I did not get any errors
dbcc checkdb (msdb) with no_infomsgs
Results: Command(s) completed successfully.
November 1, 2009 at 11:06 pm
could you plz give me some inputs..
many thanks
November 1, 2009 at 2:34 am
any sample scripts to start with...
thanks
October 29, 2009 at 12:43 am
thanks,
I went through your blog and it says we can only set page verify to CHECKSUM for a tempdb starting from SQL Server 2008. But I can see the...
October 29, 2009 at 12:34 am
Looks to me like there may have been a problem during the in-place upgrade. Not really sure where or what you need to look into as all my upgrades were...
October 28, 2009 at 3:26 pm
SELECT [col1],[col2] ,[col3]
FROM [Mydb].[dbo].[table1]
where col1 ='abc' OR col1 = 'xyz' OR col2 = 'abc/cbz.abc.client'
OR col2 ='dmzxyz/cbz.xyz.client' OR col2 = 'abc/cbz.sap.client'
OR col3 = 'abc/cbz.abc.client'
try the below:
SELECT [col1],[col2] ,[col3] ...
October 22, 2009 at 4:11 pm
thank you,
Your last post shows that your I/O subsystem is struggling to cope. with high disk usage you can see these messages
Is that OK to have disk IO high while...
October 14, 2009 at 9:40 am
Hi,
One thing I have noticed from the error log is "The below messages are occuring only on SUNDAYS when the INTEGRITY, REBUILD INDEXES & UPDATESTATISTICS maintenance jobs run"
External dump...
October 13, 2009 at 5:11 pm
Is the Maintenance plan task "Update statistics " same as running sp_updatestats??
In SQL Server 2005, we do not need to do sp_updatestats or Maintenance plan task "Update statistics " ...
October 4, 2009 at 4:41 pm
Viewing 15 posts - 286 through 300 (of 366 total)