Viewing 15 posts - 16 through 30 (of 44 total)
Hi Phil,
I agree with you but due to time constraint I could not investigate this issue in production. Prior to performing the process, I did performed the backups of msdb...
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comJuly 24, 2012 at 6:32 am
Nice article.
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comJuly 24, 2012 at 5:20 am
I've not said that this is a known issue, I said I think this is a known issue. Yes this needs to be done as last resort. In my article,...
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comJuly 24, 2012 at 5:15 am
Hi Phil,
Thanks for your comments. We are backing up the transaction log every 15 minutes. This article has been written for particular situation that is mention below:
According to SQL Server...
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comJuly 24, 2012 at 2:56 am
Thanks for this excellent article.
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comJuly 17, 2012 at 3:01 am
Thanks for this useful contribution.
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comJuly 16, 2012 at 10:14 am
Excellent article....
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comJuly 5, 2012 at 3:30 pm
Specify the date format at the start of the script as follow:
SET DATEFORMAT DMY;
<Your script>
.....
...
..
<YourScript>
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comJuly 3, 2012 at 3:18 am
Open SQL Server Configuration Manager and verify that SQL Server service is running. Also check the account under which service is running is running is not locked and its password...
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comJune 18, 2012 at 2:30 am
Rem70Rem,
1 in running column means job is currently running and 0 means its not currently running.
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comJune 8, 2012 at 9:40 am
Rem70Rem, John,
You can use master.dbo.xp_sqlagent_enum_jobs to find out what jobs are currently running on SQL server (see below):
CREATE TABLE #xp_results
(
...
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comJune 8, 2012 at 9:18 am
okbangas (3/13/2012)
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comMarch 13, 2012 at 6:40 am
anthony.green (3/12/2012)
One thing I would like to know is say I...
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comMarch 12, 2012 at 9:07 am
bgdjwoods (3/12/2012)
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comMarch 12, 2012 at 9:00 am
anthony.green (3/12/2012)
i've only ever had exposure to T-SQL as I'm a DBA, never been a developer so...
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comMarch 12, 2012 at 8:49 am
Viewing 15 posts - 16 through 30 (of 44 total)