Viewing 15 posts - 1 through 15 (of 57 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...
MCT
MCITP Database Admin 2008
MCITP Database Admin 2008
MCITP Database Dev 2008
www.jnrit.com.au/Blog.aspx
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...
MCT
MCITP Database Admin 2008
MCITP Database Admin 2008
MCITP Database Dev 2008
www.jnrit.com.au/Blog.aspx
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....
MCT
MCITP Database Admin 2008
MCITP Database Admin 2008
MCITP Database Dev 2008
www.jnrit.com.au/Blog.aspx
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...
MCT
MCITP Database Admin 2008
MCITP Database Admin 2008
MCITP Database Dev 2008
www.jnrit.com.au/Blog.aspx
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...
MCT
MCITP Database Admin 2008
MCITP Database Admin 2008
MCITP Database Dev 2008
www.jnrit.com.au/Blog.aspx
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...
MCT
MCITP Database Admin 2008
MCITP Database Admin 2008
MCITP Database Dev 2008
www.jnrit.com.au/Blog.aspx
June 23, 2011 at 6:11 am
Does your table have an index on the column in your where condition ?
MCT
MCITP Database Admin 2008
MCITP Database Admin 2008
MCITP Database Dev 2008
www.jnrit.com.au/Blog.aspx
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...
MCT
MCITP Database Admin 2008
MCITP Database Admin 2008
MCITP Database Dev 2008
www.jnrit.com.au/Blog.aspx
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...
MCT
MCITP Database Admin 2008
MCITP Database Admin 2008
MCITP Database Dev 2008
www.jnrit.com.au/Blog.aspx
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...
MCT
MCITP Database Admin 2008
MCITP Database Admin 2008
MCITP Database Dev 2008
www.jnrit.com.au/Blog.aspx
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...
MCT
MCITP Database Admin 2008
MCITP Database Admin 2008
MCITP Database Dev 2008
www.jnrit.com.au/Blog.aspx
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...
MCT
MCITP Database Admin 2008
MCITP Database Admin 2008
MCITP Database Dev 2008
www.jnrit.com.au/Blog.aspx
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...
MCT
MCITP Database Admin 2008
MCITP Database Admin 2008
MCITP Database Dev 2008
www.jnrit.com.au/Blog.aspx
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.
MCT
MCITP Database Admin 2008
MCITP Database Admin 2008
MCITP Database Dev 2008
www.jnrit.com.au/Blog.aspx
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...
MCT
MCITP Database Admin 2008
MCITP Database Admin 2008
MCITP Database Dev 2008
www.jnrit.com.au/Blog.aspx
June 4, 2011 at 11:57 pm
Viewing 15 posts - 1 through 15 (of 57 total)