Viewing 15 posts - 23,866 through 23,880 (of 39,944 total)
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
Bob Hovious (5/21/2009)
The woman also studies martial arts and plays with edged weapons.I'd rather take a technical thrashing, but it strikes me as suicidal either way.
'course in...
May 21, 2009 at 11:41 am
not that most tools require UDP 1434 access to find instances. Some ping 1433 TCP for a connection, but named instances don't show up.
The only way is to really audit...
May 21, 2009 at 11:05 am
SQLDBA is correct. One long transaction will grow a log file, or fail because of a lack of log space even in Simple mode.
You need to size for your peak...
May 21, 2009 at 11:03 am
Gail,
Have not heard anything, but I'll let you know if I do.
May 21, 2009 at 9:37 am
Andy Warren (5/21/2009)
- There is logic and value in buying a little more hardware than you need, especially if the problem goes away
Absolutely. We did the calculation one time when...
May 21, 2009 at 9:19 am
Andy Warren (5/21/2009)
- Not everyone can afford a DBA, whether we think they should or not
I agree. Not everyone needs a DBA. I wish there were a better way to...
May 21, 2009 at 9:10 am
What's a DBA? I think that's another editorial, but I do believe there are pretty good definitions for someone that functions in that role. They administer the database. They might...
May 21, 2009 at 9:03 am
The other thread is closed, please answer here.
What error are you getting? You haven't posted an error.
If it's the "server does not exist", then your service is not running or...
May 20, 2009 at 9:35 pm
Viewing 15 posts - 23,866 through 23,880 (of 39,944 total)