Viewing 15 posts - 16 through 30 (of 117 total)
just a thought. do you use maintenance plans? I had a similar problem. What turned out to be a culprit was "Attempt to repair any minor problems" switch which changed the...
November 8, 2005 at 4:46 am
From SQLIOStress documentation:
What file size should I use?
It is recommended that the file size be at least 2GB in size.
Why are larger memory and file sizes better?
This is a bit...
November 8, 2005 at 4:23 am
Do I grasp correctly that filename columns in tables sysdatabases, sysfiles and possibly sysaltfiles don't match for master and tempdb on your server? This condition shouldn't exist under any circumstances. I...
October 24, 2005 at 5:21 am
After you're done you should stop sql server from the cmd window (Ctrl+C) and start normally as a service. The trace flag will no longer be valid after this and normal...
October 18, 2005 at 10:14 am
Just out of curiosity I reproduced the situation and tested Shawn's solution and unfortunatelly it didn't work for me. What seems to solve the problem was to stop sql server, start...
October 18, 2005 at 10:03 am
What format do you use? It should be Host_name\User_name. It works without problems.
October 18, 2005 at 9:17 am
I've seen it happened when you restore, attach a database on a different server and the user that is mapped to dbo in sysusers doesn't exist (or sids don't match) in sysxlogins...
October 12, 2005 at 12:38 am
What is the recovery model of the database? If simple there's probably nothing you can do to get the situation right because the log gets truncated on every checkpoint so undo...
October 12, 2005 at 12:07 am
Try using osql instead of isql because isql shouldn´t be able to connect to a named instance unless you create an alias.
October 4, 2005 at 11:09 am
Have you tried to run the select statement from the mentioned article in every database? you can use this command to do that (should be on one line to work):
exec...
September 21, 2005 at 7:17 am
Your problem lies not in the different location of master db itself (because on its restore the file locations of the currect server are used, not the ones recorded in...
September 20, 2005 at 1:19 am
I remember reading a discussion on dbid and attach/detach operations some time ago. The general conclusion was that SQL Server assigns the lowest unused id higher than 4 (reserved for...
September 19, 2005 at 9:15 am
What SQL Server service pack you've got? Because if I remember correctly WIN 2003 SP1 and XP SP2 won't let SQL Server listen on TCP/IP unless it has SP3 or...
September 16, 2005 at 3:12 am
The better solution in my opinion is to create two procs - one on primary server and second on the standby. The first one performs backup and as a last...
September 16, 2005 at 1:55 am
see this article from MS
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q290991
September 12, 2005 at 6:17 am
Viewing 15 posts - 16 through 30 (of 117 total)