Viewing 15 posts - 23,731 through 23,745 (of 39,818 total)
truncate the log (backup with truncate only) and see if it grows again. Check the logspace (as shown above) regularly.
May 21, 2009 at 2:07 pm
Profiler, and SQL Trace, show you what is happening now. It cannot go back in time. It is a real time tool.
There is a default trace, but I'd guess that...
May 21, 2009 at 1:56 pm
LOL, probably a good plan. She is coming to PASS in November, but decide to look you up.
Last year we hit an aikido dojo one night. Hoping we can do...
May 21, 2009 at 1:56 pm
If it returns no open transactions, then either it's clear, or you have other issues.
Can you reboot the server?
May 21, 2009 at 1:47 pm
I'm confused. What do you mean by "lock"
Prevent changes?
You can remove update permissions from the table, or the column, for a user/role.
May 21, 2009 at 1:35 pm
You can set a step to go to the next step on success, stop on failure. Set up a starting step to check the day of the month. If it's...
May 21, 2009 at 1:27 pm
We have a lot of scripts on this site that can help you.
May 21, 2009 at 1:26 pm
are you doing in place or side by side?
The new 2008 server will need to restart in single user mode at some point, I believe, so you can't have people...
May 21, 2009 at 1:22 pm
That's an interesting question. My guess would be no since the proc license typically supercedes the CAL licenses, but it's an either OR.
Are they authenticated users (in AD)?
May 21, 2009 at 1:21 pm
You could set the db to read only as well. That won't prevent the backup, or access by users, but it will stop them from altering data.
May 21, 2009 at 1:19 pm
If you have a question, please ask it. Don't present information and expect us to understand.
Second, you need to make an attempt. We are not here to do homework/exams/interview questions....
May 21, 2009 at 1:17 pm
First, post in the DTS forum (I'll move this).
Second, you need to pick the columns to move in transfer data task. Leave the identity column out if you don't care...
May 21, 2009 at 1:16 pm
You can use
kill (spid)
if you need to clear that connection. Once that is done, the log should not necessarily grow anymore. To find a good peak size, I'd...
May 21, 2009 at 1:00 pm
If this is in Simple mode (right click the database, properties, options), then you have an open transaction that is preventing space from being reused.
Run
dbcc opentran
to find out what's...
May 21, 2009 at 12:37 pm
Viewing 15 posts - 23,731 through 23,745 (of 39,818 total)