Viewing 15 posts - 14,596 through 14,610 (of 26,486 total)
I know I'm late to the party, but I was reading the question and I'm partially lost, in that I'm not sure what your expected results are based on the...
May 18, 2011 at 12:17 am
What edition of SQL Server 2005 are you running and are you running on a physical or virtual server?
May 12, 2011 at 11:23 pm
john.arnott (5/6/2011)
May 7, 2011 at 12:40 am
Syed Jahanzaib Bin hassan (5/4/2011)
http://msdn.microsoft.com/en-us/library/ms190913.aspx
open your principal database on SSMS SQL Server Management Studio and then click on new query and then pass this statement
ALTER DATABASE yourdatabase SET PARTNER TIMEOUT...
May 4, 2011 at 6:25 am
Craig Farrell (5/3/2011)
May 4, 2011 at 12:41 am
SQLRNNR (5/3/2011)
mike 57299 (5/3/2011)
I am currently doing a full backup at 3am and log transaction backups every hour from 5 am - 6pm. I also have a second...
May 3, 2011 at 10:43 am
SQLRNNR (5/3/2011)
Syed Jahanzaib Bin hassan (5/3/2011)
After latest full backup there is no need of previous log or previous differential backup they are useless,
I disagree with this statement. Point in...
May 3, 2011 at 10:40 am
If you truncate the t-log you will not be able to use a previous full backup to start a recovery if a more current full backup file turns out to...
May 3, 2011 at 10:36 am
mark hutchinson (5/3/2011)
Thank you for your patience. I must not be asking my question in the right way. Sorry. I'll try one last time.
There are two parts...
May 3, 2011 at 8:44 am
You may also want to invest in an introductory book on T-SQL. I don't have any titles handy as I have been working with T-SQL for over 12 years....
May 2, 2011 at 2:46 pm
In addition to Google, Books Online (BoL) is also your friend. You can access it by press the f1 function key while in SSMS. Search for SELECT.
May 2, 2011 at 2:33 pm
Here is a tip. Read the first article I reference below in my signature block regarding asking for help. Follow the instructions regarding what you should post when...
May 2, 2011 at 1:23 pm
Just wanted to add my 2 cents as well. Very well done. I will be adding these routines to my toolbox as well.
I'm curious, I'm wondering if I...
May 2, 2011 at 4:29 am
I have to agree with Gail. I have also reported the post to ssc suggesting that the attachment be deleted as it may violate Microsoft NDA agreements.
May 1, 2011 at 10:51 am
george sibbald (5/1/2011)
May 1, 2011 at 10:24 am
Viewing 15 posts - 14,596 through 14,610 (of 26,486 total)