Viewing 15 posts - 181 through 195 (of 285 total)
2 Tim 3:16 (3/19/2010)
(Assuming you can logon to the server). Stop the SQL Server service and take a cold backup of the .mdf and .ldf files. Restart...
March 19, 2010 at 3:23 pm
We work at a secure site, and telnet has been removed. That is why I was using the portping utility I mentioned.
March 18, 2010 at 10:28 am
Thanks for your response!
Prior to posting, I submitted a ticket to our Network folks to make sure that the port is open between my workstation and the server. They say...
March 18, 2010 at 9:44 am
Trying to get a response...
All help is appreciated!
March 18, 2010 at 7:10 am
Thanks for the tip. However, when I do that, it brings up SQL Server 2000 information. Are the error codes the same for both versions?
March 12, 2010 at 11:07 am
Lowell (2/10/2010)
OK here's my prototype for scripting out the traces;
Nice job!
February 10, 2010 at 12:04 pm
SQLBOT (2/10/2010)
that's brutal.If it's a big concern, I'd not hesitate to robocopy the files to a fileserver and let them back it up from there.
Agreed. We copied needed files elsewhere...
February 10, 2010 at 8:39 am
Lowell (2/10/2010)
Thanks for sharing your query. This is a keeper.
February 10, 2010 at 8:32 am
SQLBOT (2/10/2010)
How often are tape backups running?
Actually, this is the "root cause" of the problem. [GRUMBLE]It depends on who you ask.[/GRUMBLE] This is a locked down shop in which the...
February 10, 2010 at 8:30 am
Lowell (2/10/2010)
for me, reverse engineering is to be able to script out any and all traces that exist on the server;
Yes, that is the kind of output that I would...
February 10, 2010 at 7:22 am
SQLBOT (2/10/2010)
You CAN turn it off. but why?
I must have misspoken somewhere. I do *not* want to turn off the default trace. I just need more rollover files so that...
February 10, 2010 at 7:19 am
SQLBOT (2/8/2010)
select * from :: fn_trace_getinfo(0)
The output from this query matches up with the files that are being generated on the server:
traceid property ...
February 10, 2010 at 6:41 am
Richard M. (2/4/2010)
See here and here for references
I have seen this implemented as Triggers at DB level...
February 4, 2010 at 2:33 pm
SQLBOT,
This shows some nice possibilities for us. Apparently, something is auto-deleting the old files (and I am having them restored).
Do you know how to configure the auto-deletion so that we...
February 4, 2010 at 12:46 pm
Thanks. This helps. I see a couple databases named ReportServerTempDB and one named MossReportTempDB. I'm not sure what MossReportTempDB is. Is that a "standard" database name for Microsoft Office SharePoint?
December 29, 2009 at 7:29 am
Viewing 15 posts - 181 through 195 (of 285 total)