Viewing 15 posts - 3,316 through 3,330 (of 4,745 total)
drive space usage is obviously a limiting factor. Cannot give a percentage full rule of thumb because that depends on the size of the disk. Sever is full whenever any...
October 8, 2009 at 6:38 am
sounds like you are a small shop and may not have the luxury of test environments or being able to do a side by side upgrade (upgrading by migrating to...
October 7, 2009 at 12:59 pm
Melton (10/7/2009)
You also cannot do WITH DIFFERENTIAL against the master database, only FULL.
good point! I guess thats the error then!
October 7, 2009 at 12:18 pm
Jake, thats a big question and the answer to it would be very long to type out and vary by server anyway, so you might not get replies. Your best...
October 7, 2009 at 10:39 am
that looks like a third party tool. there is not enough info in the post to answer your question. Look in the SQL error log hopefully it will give more...
October 7, 2009 at 10:36 am
were you using SSMS to try and connect?You will have to use SQLCMD.
If that message still occurs someone or something is beating you to the single connection. If you have...
October 7, 2009 at 7:08 am
what state is your secondary database in. loading or read only? If its in read only already you will be able to connect to it to read data and see...
October 7, 2009 at 7:00 am
thats a most unusual error message. I would hazard a guess the table has a trigger on it that prevents multiple updates.
October 4, 2009 at 2:40 pm
from msdn:
If the database is using the simple recovery model, an automatic checkpoint is generated whenever the number of log records reaches the lesser of these two values:
The log...
October 3, 2009 at 3:23 pm
is this SP2 and on a cluster by any chance?
see
upgrade to SP3 might also be an option.
be sure all the master and resource database files are in the same directory.
October 2, 2009 at 2:53 pm
I suggest backup\restore to get the database across. detach\attach is an alternative but copy the files rather than move else you have no backout.
the users will come across with the...
October 2, 2009 at 1:01 pm
backing up to tape might be useful so you can re-use tape.
backing up to disk no advantage at all.
If using the maintenance plan backup to file, it will suffix...
October 2, 2009 at 7:32 am
Danb, did the bounce at the weekend resolve the problem.?
September 30, 2009 at 1:10 pm
Viewing 15 posts - 3,316 through 3,330 (of 4,745 total)