Viewing 15 posts - 23,956 through 23,970 (of 26,486 total)
And then make sure you have periodic transaction log backups running to keep the transaction log from growing so big again.
October 31, 2008 at 12:51 pm
I have gotten side tracked by work and other issues. From my analysis, it appears the each fiscal quarter follows the following pattern 4 weeks, 5 weeks, 4 weeks....
October 31, 2008 at 12:28 pm
Seth,
Looks like you went the same direction I was look at as well, you just beat me to the post. I checked out your code, and it seems solid...
October 31, 2008 at 12:08 pm
To be sure, we aren't talking about 60 minute blocks based on the first call for a given case, corret? That is why the 2:30 and 3:00 calls are...
October 31, 2008 at 11:55 am
It is hard to provide you with the code you need since you haven't provided us with anything to really help you. Read the article below, it will so...
October 31, 2008 at 11:10 am
Could you provide us with the DDL of the table, some sample data, and the expected results? For guidance, read the article mentioned below.
October 31, 2008 at 10:59 am
shnex (10/31/2008)
I can't find this anywhere...
I will come with other examples ...later,because now I need a break
I believe you and I will...
October 31, 2008 at 10:34 am
If you change msdb from simple to full recovery model, run a full backup. The transaction log backup of msdb will continue to fail until a full backup is...
October 31, 2008 at 10:08 am
I'm going to point you right back to BOL. I have written a few scripts to build some tables based on other tables and everything I needed to know...
October 31, 2008 at 9:27 am
The model and msdb databases use the simple recovery model by default. For model, a periodic full backup is all the may be necessary. For msdb, you can...
October 31, 2008 at 9:21 am
You can either start looking at SMO for ways to do this, or start researching the system views. Some of the tables are sys.tables, sys.columns. Start with these...
October 31, 2008 at 9:09 am
Two things. You will need to script everytyhing from your SQL Server 2005 Express database, ensuring you do so for SQL Server 2000. This shouldn't be a problem...
October 30, 2008 at 8:36 pm
Hard to read the error message. Just a guess at this point, but it looks like it couldn't create a subdirectory. Two possibilities, permissions or lack of space.
October 30, 2008 at 8:31 pm
That could be quacking I hear in the background. :w00t:
October 30, 2008 at 4:26 pm
You can't backup the transaction log of databases using the simple recovery model. In addition, master can not be changed from simple recovery model.
You should seperate the system and...
October 30, 2008 at 4:25 pm
Viewing 15 posts - 23,956 through 23,970 (of 26,486 total)