Viewing 15 posts - 31 through 45 (of 146 total)
I didn't think Mirroring was supported until SP2.
July 22, 2009 at 7:17 am
We have a 3rd party product called Apex SQL Recover. You can recover dropped tables w/o any backups. However, (As Jeff Modem stated) it reads the disks and...
July 21, 2009 at 9:29 am
Just a shot-in-the-darh here but I've had problems on clusters if I'm logged on to both nodes at the same time. I think you may need to install on...
July 17, 2009 at 8:07 am
Our standard is for all application program files (binaries) installed on the E: drive. (Including SQL Server). I have clustered servers and have done this using...
July 13, 2009 at 1:03 pm
On the "Components To Install" screen select the Advanced botton.
Highlight "database Services" and select BROWSE.
Change the drive letter only. Do not change the entire path.
save (this is where...
July 13, 2009 at 7:47 am
John,
Just wanted to say your last post took a lot of courage. I admire you admitting points where you were wrong and willing to move forward in a...
July 6, 2009 at 1:32 pm
keep in mind that this will not keep out Access or Excel logins. You'll need to add those if desired. Come to think of it, you probably just...
July 6, 2009 at 1:04 pm
If you're going to use a logon trigger keep a couple of commands ready to go if needed:
DROP TRIGGER login_trigger ON ALL SERVER
DISABLE Trigger ALL ON ALL SERVER;
DISABLE Trigger login_trigger...
July 6, 2009 at 12:58 pm
Sorry, I don't know what the overhead is (If Any) for a logon trigger.
July 6, 2009 at 12:15 pm
Actually, I got thinking about this some more, and I had it right the first time. You want the App Id's listed and if they're trying to use SSMS...
July 6, 2009 at 12:14 pm
ooops, sorry, this code is bad. It actually should be just the opposite. use the developers id's and not the app id in the script....
July 6, 2009 at 8:03 am
I often have 3rd party apps that insist the App id have 'sa' or some other high level acccess. if the App connects, fine, but I need to keep...
July 6, 2009 at 8:02 am
Just trying to clarify a little.....
Your results of "total Avail Mem, KB" is the total available free space in the Mem-to-Leave VAS? and the "Max Free Size KB" is...
July 6, 2009 at 7:47 am
Thanks Abhay, really appreciate it. The books speak of proportional fill in cloudy terms and I was looking for someone who actually had experience with it.
What about the auto-growth...
July 2, 2009 at 6:56 am
so sorry, missed the mirrored part. George is 100% correct....
June 30, 2009 at 7:36 am
Viewing 15 posts - 31 through 45 (of 146 total)