Viewing 15 posts - 6,721 through 6,735 (of 9,253 total)
Hi
use this and execute from a sql server agent job step 😎
Option Explicit
'Delete all SQL Server backup files more than 8 days old
Dim oFS, oSQLBackupFol, oFol, oFil
Set oFS =...
August 30, 2011 at 5:55 am
the documentation for that revlogin script tells you to carefully examine the output before executing it. There are certain logins that you do not want to re create on the...
August 30, 2011 at 5:48 am
If you're clustering SQL Server then you need to cluster MSDTC. If the clustered SQL Server instance fails over and the local MSDTC is in use then after failover the...
August 30, 2011 at 5:44 am
jpSQLDude (8/29/2011)
Tape? You guys are funny!But seriously, most places I've worked do NOT take backups seriously.
you want your data on every media possible. I used to work for a software...
August 29, 2011 at 12:03 pm
Can you post a screenshot of what you are trying to change?
August 29, 2011 at 10:49 am
It's still unclear what you are trying to achieve, are you wanting to change the database owner?
August 29, 2011 at 10:39 am
shew (8/29/2011)
Thanks, that helps a lot. I plan to check this out after I get home from work.
😉
August 29, 2011 at 3:15 am
shew (8/28/2011)
Perry,Networking is not a strong point for me (I normally use DHCP at home, and IP assignment is performed by a different group at work).
🙂 hey no worries. Again...
August 29, 2011 at 3:05 am
parissa_bakhshi (8/28/2011)
I don't Use multipathing.
doing so would provide more performance and redundancy.
parissa_bakhshi (8/28/2011)
August 29, 2011 at 2:45 am
BrentMc (8/28/2011)
use the EncryptByKey and DecryptByKey functions.
you may also use certificates (DecryptByCert and EncryptByCert) and asymmetric keys (DecryptByAsymKey and EncryptByAsymKey)
August 28, 2011 at 4:18 pm
what is the recovery model of the database for which you want to remove the extra file?
August 28, 2011 at 12:17 pm
exactly which wait type are you seeing, can you provide a sample?
can you provide more detail on your iscsi setup, what initiator software are you using, do you have multiple...
August 28, 2011 at 12:09 pm
You all sorted now?
August 28, 2011 at 7:47 am
shew (8/27/2011)
the attachment had some volume 2 (20 GB) and initiator 2 stuff in it. Did I miss something?
No, vol2 is an extra volume I am using
August 27, 2011 at 8:32 am
Viewing 15 posts - 6,721 through 6,735 (of 9,253 total)