Viewing 15 posts - 121 through 135 (of 174 total)
February 24, 2005 at 8:07 am
Thank you Sa24 and John for your ideas! I immediately will try your suggestions
February 23, 2005 at 6:03 am
Thank you for your reply
I'm not fastidious and our cluster doesn't perform criticial services, so there could be the simplest way to get...
February 22, 2005 at 8:01 am
There are three schedules: backup, copy\load, load in a log shipping. And there are not schedule for a proccess lenght, only for intervals of these three types. As I remember...
February 21, 2005 at 11:32 pm
1. No. Only in case when you will change servers roles ex.: after change your old primary would be new secondary and vice versa
2.Only updates
3. It should be if you...
February 20, 2005 at 11:47 pm
Hi, what about your DB backups? Do you have them? If so how often have you made them?
February 20, 2005 at 11:25 pm
Finally it works again!
Yes I think that my both servers where rebooted in tens times. Don't as me what concrete I've done, you wouldn't get an answer
February 18, 2005 at 5:16 am
Detailed errors:
The description for Event ID ( 17055 ) in Source ( MSSQL$INST1 ) cannot be found. The local computer may not have the necessary registry information or message...
February 18, 2005 at 12:05 am
Hello, sa24
Do you mean I must delete these :
Locate, and then delete the %drive%:\Program Files\Microsoft SQL Server\MSSQL\Binn folder
and registries:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer$InstanceName
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT$InstanceName
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServerADHelper
If so it doesn't help. My installation with the same...
February 17, 2005 at 11:10 pm
I don't understand have you tried to shrink it?
Quite simple explanation of doing this in BOL "How to shrink a database (Enterprise Manager)" Or maybe I missed something?
February 17, 2005 at 11:15 am
Agreed with Yelena. Your both SQL server services and sqlserveragents must run under the same local admin account (ex. Adm) which you added previously. Then as Adm you can connect through EM to...
February 14, 2005 at 11:44 pm
I had the same problem on XP box when I tried tried to install SQL Enterprise 2000 . I was allowed to install only client tools. When I got developer edition,...
February 14, 2005 at 7:17 am
I guess your cursor is built under wrong syntax. I think you missed one 'fetch next' command. For more info see BOL
It's only my personal oppinion
February 14, 2005 at 7:06 am
Hi,
So you see these grayed options on the server where you are not local admin... In this case it should be so. If you want to change these options you...
February 14, 2005 at 12:10 am
Yes it is possible through enterprise manager. In logins you'll see sa account. Double Click on it and type new password twice
But you need to have system administrator or local...
February 11, 2005 at 6:44 am
Viewing 15 posts - 121 through 135 (of 174 total)