Viewing 15 posts - 1,486 through 1,500 (of 1,654 total)
Most likely one or more of your databases is in simple recovery mode, which will cause a maintenance plan transaction log backup to fail.
Look in the maintenance logfile for...
January 2, 2006 at 9:11 am
Chris,
in my experience there are 3 possible reasons why a job would not run.
1. SQL Agent is not running
2. The schedule isn't enabled
3. The scheduled time has already passed
For the...
December 19, 2005 at 12:31 pm
From BOL:
Right-click the Replication folder or any of its subfolders, and then click Launch Replication Monitor.
Markus
December 19, 2005 at 12:10 pm
Roger,
where's actually an issue with task manager showing the wrong amount of memory used by sql server if your using more than 3gb. Use Performance monitor and you see the...
December 19, 2005 at 12:02 pm
Not sure if this is related, but I experienced the same error when trying to creae a unique clustered index in Management Studio. The error complaint about duplicate values, even...
November 29, 2005 at 9:35 am
Chris,
one thing to keep in mind then attaching a SQL 2000 datbase is that most new features are only availbale after you change the compatibility level to 90.
Markus
November 23, 2005 at 6:40 am
I agree with Richard.
Even though I guessed my answer (D), the Explanation don't make things any clearer and without a SQL2005 server at hand I can't check the real...
November 9, 2005 at 10:00 am
Kirk,
thnks for the reply, but while you can delete a package by connecting to Integation Services there's no edit or properties option. Do I have to export the package...
November 1, 2005 at 11:19 am
Philip,
I've never tried and I wouldn't advise doing it. I remember a customer which once restored his master database from an old machine to a newer one and it turned...
October 13, 2005 at 10:59 am
I see that the properties on the log file have Automatically grow file checked and Restrict file growth to 6GB. I thought this was pretty much saying to set a...
October 12, 2005 at 12:53 pm
see my answer in the replication form
October 12, 2005 at 12:03 pm
I had the same issues a while ago and created a script which cleans all the leftovers of merge replication.
I don't like to post it because it's quite rough and...
October 12, 2005 at 12:01 pm
Isabelle,
the 85 % threshold is based on the current logfile size not on the max allowed size of 6Gb.
If you only want the logfile backuped then 85 % of 6...
October 12, 2005 at 11:52 am
At first sight I would say you don't do anything wrong, and executing the code works. What could cause your problem is the "with file = 1" option.
If your backup device...
October 2, 2005 at 8:14 am
Which account do you use ? Is it a domain account or a sql account ? Maybe the password has changed .
M
September 26, 2005 at 1:32 pm
Viewing 15 posts - 1,486 through 1,500 (of 1,654 total)