Viewing 15 posts - 271 through 285 (of 326 total)
FYI - I just did a cut and paste from your post on 2 servers and both worked.
February 10, 2006 at 6:47 am
From BOL:"Execute permissions default to the public role for a user changing the password for his or her own login"
If the user is already logged in, then the user can...
February 10, 2006 at 6:37 am
Yes - you can have an active/active arrangement. Just be sure to factor in performance degradation when you are trying to balance the nodes and determine how much is acceptable.
February 9, 2006 at 10:05 am
Log shipping does require some manual intervention.
My experience with 2 way clusters for HA has been positive. In most cases, if the active node goes down, the failover to...
February 9, 2006 at 7:53 am
I guess I needed to be more "definite" . What is the time frame for failover? Do you require High Availability (this would...
February 9, 2006 at 7:24 am
Please define what you believe to be a failover situation.
February 9, 2006 at 6:48 am
Don't forget to check the applications that access the data. Changing collation may "break" something in an application.
February 3, 2006 at 7:06 am
February 3, 2006 at 6:37 am
"It is probably similar thing with the database backups that have identifiers that this is a backup file. Any other file with extension BAK was not deleted."
I'm fairly certain the...
February 1, 2006 at 10:56 am
On the off chance that all you want to know is where to find the number of days to keep before the plan will delete the backup files, it's in...
February 1, 2006 at 7:37 am
It looks like sysdtspackages90 contains a row for each maintenance plan. At least it does on my databases. I just have some test stuff and very littel else so it's...
January 24, 2006 at 9:57 am
Maintenance plans are still stored in MSDB. Sysdbmaintplan_jobs contains the job_id linked to the maintenance plan.
January 24, 2006 at 6:44 am
If I remember correctly, right click on Database Engine in the Registered Servers window and the menu should have "Previously Registered Servers" in it. Any SQL 2000 servers that were ...
January 18, 2006 at 7:08 am
This is very different from 2000 (why should this be the exception :mad
Open up Object Explorer, right click on the database that has the...
January 16, 2006 at 12:40 pm
I don't know anything about the Symantec product but you might try using the db_backupoperator role with the account. If it doesn't work, it may give more information about what...
January 12, 2006 at 6:45 am
Viewing 15 posts - 271 through 285 (of 326 total)