Viewing 15 posts - 1,171 through 1,185 (of 1,790 total)
Not trying to pass the buck on this one but the errors seem pretty unique and due to the fact that you are on a production system I would escalate...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 22, 2008 at 8:37 am
In order to stop failover to the other node you should stop the SQL Server services using the Cluster Manager tool prior to restarting that physical server. Then you should...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 22, 2008 at 8:25 am
You should be able to browse them in IIS, right click my computer, manage, expand services and applications and you should see IIS in there. Expand that to find default...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 19, 2008 at 3:45 pm
And you are trying to connect to http:\\localhost\reports? What are you seeing if you try to connect to http:\\localhost\reportserver?
When I have problems like you are describing I delete the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 19, 2008 at 2:20 pm
A bit confused by the last post but that is ok, it is pretty easy to do with me. 🙂
If you have a SQL Server 2000 backup then you can...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 19, 2008 at 1:34 pm
Jason - As far as I know you are correct and you will have to add another task. I started writing an article about the xp_delete_file extended stored proc but...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 19, 2008 at 12:02 pm
Agreed. There are many cases where people think that partitioning is the solution for performance and it is not unless used correctly and in the right situation. We just went...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 19, 2008 at 8:12 am
Are you updating the stats on the ms* related replication tables? If so, then I have experienced this and we do it once a day but also rebuild indexes as...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 18, 2008 at 9:19 pm
Better bet is to either move the previous days files into another folder prior to backup or add the date on to the end of the new file being generated...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 18, 2008 at 9:15 pm
Todd - Are you restoring over an existing database? Everything that I am finding on the web is indicating a file access issue, i.e. the file that is specified in...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 18, 2008 at 1:17 pm
No it didn't go to a recycle bin and there are ways to get it back. Check out the following posts from earlier today.
http://www.sqlservercentral.com/Forums/Topic572003-1291-1.aspx
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 18, 2008 at 11:49 am
It is SP4 according to the version database so, the question has to be are you pointing to the correct instance in Query Analyzer?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 18, 2008 at 11:47 am
....or take a log backup, restore the latest full backup to a different db name with norecovery apply the log backup that was just taken to the point in time...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 18, 2008 at 7:21 am
If you are sure you are executing that in the database with that table then the other problem could be that the table is owned by someone other than dbo?...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 18, 2008 at 6:51 am
I don't know that you can have the cmdexec tasks wait for completion as it really just fires off the batch and reports complete if there were no errors with...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 18, 2008 at 6:34 am
Viewing 15 posts - 1,171 through 1,185 (of 1,790 total)