Viewing 15 posts - 226 through 240 (of 2,636 total)
If sa isn't available, my second choice would be the SQL Agent service account. If you want a less privileged login to be the job owner, you'll need to...
October 16, 2009 at 9:39 am
Hi Mir,
My original post assumed that the two domains would coexist for a period of time so you could add the new domain logins to SQL Server and duplicate the...
October 15, 2009 at 3:43 pm
Please don't duplicate posts. New replies in this thread: http://www.sqlservercentral.com/Forums/Topic803368-9-1.aspx
October 15, 2009 at 9:38 am
We had to do this last year when we moved to a new domain. We modified the logins on each SQL Server instance. Here's how we handled it:
1....
October 15, 2009 at 9:35 am
I don't think you can find that out retroactively, but you can create a Server level DDL trigger to log information when a login is added. See DDL triggers...
October 15, 2009 at 9:26 am
I recommend reading Inside SQL Server 2005 by Kalen Delaney: http://www.microsoft.com/learning/en/us/book.aspx?ID=7436&locale=en-us
October 15, 2009 at 9:18 am
This is usually done with Integration Services (SSIS). If it's a one-time import you can use the Import/Export Wizard in SSMS. Just right-click on the destination database, select...
October 14, 2009 at 10:24 am
1. In SQL Server Management Studio, right-clilck on SQL Server Agent, select new, select job. One
the General page, give the job a name. On...
October 14, 2009 at 10:01 am
You should check out copy-only backups in BOL. They're recorded in the backup set, but don't affect the sequence of backups.
October 12, 2009 at 10:21 am
If you don't have package logs or auditing, you'll have to script out all the packages and search for the table name. This script helps with that: http://www.sqlservercentral.com/scripts/Miscellaneous/31613/
October 12, 2009 at 9:51 am
I only use the SQLAgentUserRole in one situation and it seems secure enough, even though I have a proxy assigned to it. I think it's safe as long...
October 8, 2009 at 2:38 pm
I see this error occasionally when the tape copy is running a little longer than normal and has the backup file open when a backup job runs. We've alleviated...
October 8, 2009 at 2:26 pm
I don't do this myself because we overwrite backup files, but if you search this site for something like "delete backups", you'll find tons of scripts and advice on how...
October 8, 2009 at 2:22 pm
cidr (10/7/2009)
Hi there,@enabled=1,
@freq_type=4,
@freq_interval=1,
@freq_subday_type=4,
@freq_subday_interval=15,
@freq_relative_interval=0,
@freq_recurrence_factor=0,
@active_start_date=20080912,
@active_end_date=99991231,
@active_start_time=0,
@active_end_time=235959
For future reference, those are documented in BOL as part of the sysschedules sytem table, but Silverfox's idea...
October 7, 2009 at 9:36 am
Also, nothing says backups have to run at the top of the hour. You could schedule diffs to run at 20 after or half-past.
October 6, 2009 at 4:47 pm
Viewing 15 posts - 226 through 240 (of 2,636 total)