Viewing 15 posts - 1,786 through 1,800 (of 4,745 total)
its not made obvious but it will timestamp them, you can also use the maintenance cleanup task to delete them by date, which your code does not cater for.
dont use...
May 25, 2011 at 2:50 pm
do you mean drop the index and then recreate or using create index with drop_existing?
using alter index means indexes enforcing PRIMARY KEY and UNIQUE constraints can be rebuilt without dropping...
May 25, 2011 at 2:44 pm
you could achieve this via a maintenance plan.
May 25, 2011 at 2:22 pm
grant it dbcreator role, and for databases not created under the security of that ID add it to the db_owner role
May 25, 2011 at 2:05 pm
you would create competing resources for memory so may have a slight degradation there.
On the other hand you would have to have sperate disk resources for the new instance so...
May 20, 2011 at 6:47 am
well, thank you for taking the time to feedback.
May 20, 2011 at 3:52 am
log backups definitely the K. full and diffs - it depends, but I would not expect to have the space on my log drive anyway so I would say K.
It...
May 19, 2011 at 3:41 pm
GSquared (5/19/2011)
Can your boss arbitrarily sell you to a different employer,
thats a pretty good description of outsourcing someone (or a department) 🙂
and you will be hunted down and killed...
May 19, 2011 at 3:34 pm
good point, what to do when a failover occurs. As a share it could be visible from both nodes?
I am sure I saw this setup on a 2000 cluster years...
May 18, 2011 at 4:33 am
perry, can the instances share a backup drive? would this be set up as a file share?
May 18, 2011 at 3:57 am
there is one for SQL2005, but it has been closed as 'by design'. I have requested it be reopened
please vote!
May 17, 2011 at 3:24 pm
restore or recovery?
yes. This is a severe HW error likely only fixable by restore. EOF is not where SQL expects it to be.
In our case it was caused by a...
May 17, 2011 at 3:09 pm
use the import wizard to read the file into a database table, then loop through that table backing up the databases.
May 17, 2011 at 8:58 am
anything distinctive about the databases that would allow you to select their names out from master.sys.databases?
May 17, 2011 at 8:32 am
thankyou brian but they require to do more than disable\enable. they would want to amend the contents of job steps.
I am going to go with the setup described above, but...
May 17, 2011 at 7:37 am
Viewing 15 posts - 1,786 through 1,800 (of 4,745 total)