Viewing 15 posts - 28,876 through 28,890 (of 39,771 total)
This will work if each user is logging onto the machine with their account. If they are sharing logins to Windows, then you need to use SQL Server accounts. Depending...
April 21, 2008 at 10:02 pm
No way to limit this. Other than perhaps have a job that counts the alerts and disables the alerts after xx firings. That would be a kludge.
This is the kind...
April 21, 2008 at 10:01 pm
Red Gate has a good product (I work for them), slightly different features than Litespeed, different price point.
Hyperbac is written by the guys that originally wrote Litespeed many years ago.
April 21, 2008 at 9:54 pm
Use the ability of the OS Services to send a note when the service stops. You can script the mail sending from there.
April 21, 2008 at 9:52 pm
One per database is correct.
April 21, 2008 at 9:51 pm
I think this is available as an option. Might not be in the wizard. Did you open the maintenance plan and check if it's in there after the wizard?
April 21, 2008 at 9:51 pm
You don't need admin costs, you need savings based on GB. It's the cost of your GB per year in media, people, time, etc.
The compression rates for Litespeed/SQL Backup/Hyperbac are...
April 21, 2008 at 9:49 pm
No way to tell. Could be a lot or little, depending on what the server does.
April 21, 2008 at 9:45 pm
Not sure that's true. I'd be curious if there were proof somewhere.
Named pipes is an older technology, super-seeded by TCP Sockets. Not sure it's better or worse, mostly think the...
April 21, 2008 at 9:45 pm
This? http://www.sqlservercentral.com/scripts/Maintenance+and+Management/62222/
Search "Job Information" here on the site and then limit by scripts.
April 21, 2008 at 9:41 pm
You really want an audit table for every table you audit. Otherwise you introduce a scale issue and potential hot spot in your application.
If you don't want to change the...
April 21, 2008 at 9:38 pm
I think the licensing is set at fairly standard pricing. If you have doubts about what you need, contact Microsoft. They're fairly good about answering questions and giving you fair...
April 21, 2008 at 9:35 pm
Set up a job to run the package. You can even set the package to run when a value in a tab le is set to a certain number. Allow...
April 21, 2008 at 9:34 pm
Run SQLIO to test the writes on the db server. You should be able to guess the bandwidth from there or issues with the other server.
Not sure what you can...
April 21, 2008 at 9:32 pm
Viewing 15 posts - 28,876 through 28,890 (of 39,771 total)