Viewing 15 posts - 1 through 15 (of 56 total)
Can you confirm whether you are wanting to implement Transactional replication or log shipping ? These are different. Are you requiring your secondary server instance of SQL server to be...
August 7, 2011 at 5:33 am
In your wsfc, if you look in the failover cluster manager you should have a resource group for your installation of SQL server. This will have been created when you...
July 6, 2011 at 1:07 pm
You do not need to script them 1 by 1. You can script them all in 1 go. Or inside of ssis you can create a package to copy objects....
June 28, 2011 at 5:56 am
I understand your frustration. I have been in a situation where it was forced on us to move from HDS to netapp. You should be able to run a restore...
June 23, 2011 at 6:35 am
Ninja's_RGR'us (6/23/2011)
Rhox (6/23/2011)
You can save this query and run the Database Engine Tuning Advisor against it...This will create scripts to make your indexes
NEVER a good idea to blindly do what...
June 23, 2011 at 6:27 am
It is a little difficult to get your head around the new concept of not having a physical .bak file. I am assuming your company has purchased snap manager for...
June 23, 2011 at 6:11 am
Does your table have an index on the column in your where condition ?
June 23, 2011 at 5:54 am
As stated the use of the upgrade advisor will inform you of anything you need to change or rectify to allow you to migrate. On a dev\ test environment either...
June 21, 2011 at 5:20 am
Ok all this is hypothetical until you can actually connect to your production server to get the actual information and determine your requirements.
If your tapes can only hold 1...
June 21, 2011 at 4:10 am
As I said previously, to determine a backup strategy suitable for your situation, you need to know an understand your RPO & RTO. Ie if there is a problem how...
June 20, 2011 at 11:55 pm
How did you come to the decision that you need a full backup taken on a Monday , with differential backups taken on every other day , with 5 minute...
June 20, 2011 at 3:47 am
Does this insert that the developer is doing have to be done manually ? You could set up an automated job to call an ssis package as indicated above or...
June 17, 2011 at 1:25 am
Knowing your growth rates is a very useful thing. To make it easy for yourself in the future once you have created your SQL script being called by your SQL...
June 11, 2011 at 5:12 pm
You may have it already in your software suite, visual studio 2010 has a compare that you could use.
June 10, 2011 at 2:04 am
From your windows 7 machine are you able to connect via sqlcmd ? What protocols are enabled on your server ? Named pipes, tcp/ip ? Combination of or only a...
June 4, 2011 at 11:57 pm
Viewing 15 posts - 1 through 15 (of 56 total)