Viewing 15 posts - 91 through 105 (of 109 total)
What if I was to put the databases from sqlc5d1, that I am consolidating over to cluster12, and put the dbs on the default instance for the cluster, cluster12, not...
June 24, 2009 at 1:48 pm
I wish I had time to worry about such things. 🙂 I would just accept it and add value elsewhere, cost vs benefit and all that.
June 24, 2009 at 1:34 pm
- disable all logshipping jobs
- restore your primary server database from backup
- restore the same database backup on to the secondary server but in the correct state (you can apply...
June 24, 2009 at 1:07 pm
You are correct and I am not aware of anything that would preallocate space but do wonder what your motives are if you have a dedicated disk? You will...
June 24, 2009 at 12:58 pm
Be careful here. If you are moving default instances from three servers and transferring them to named instances on a cluster you will be forced to change the applications....
June 24, 2009 at 12:26 pm
Aha, didn't know that. Thanks, might be useful going forward.
June 24, 2009 at 9:09 am
You can't have one subscription generate multiple docs though could you?
June 24, 2009 at 8:50 am
You would have to create new files and then move the objects into those new files. BOL can help with this.
June 24, 2009 at 3:24 am
There will be others with experience in doing this and maybe better ideas but to my mind you would need to create a report that generates all customers in one...
June 24, 2009 at 3:22 am
As gail mentioned, if you change your server name from bob to harry, your default instance will be connected to via harry not bob.
If you have another instance called audit,...
June 23, 2009 at 9:51 am
Gail is correct, if you want a more friendly name for whatever reason you can create an a record in DNS which directs the request to the same IP address.
Steve.
June 23, 2009 at 9:32 am
Attached against some data that was handy. I have shown you what it was prior and then a column once the case is taken into account. If the...
June 23, 2009 at 8:56 am
On 1.
Use a case statement to make it equal the value where one exists but if Null then put in the string of 'Null'. This string will then be...
June 23, 2009 at 5:34 am
We have something similar but we create one page per customer in SSRS. (Obviously multiple pages if they have more than one page of data). This is simple...
June 23, 2009 at 1:45 am
We had a different scenario to you but I believe the same underlying cause. If you have not set up Kerberos for your servers, it loses the security token,...
June 23, 2009 at 1:40 am
Viewing 15 posts - 91 through 105 (of 109 total)