Viewing 15 posts - 46 through 60 (of 120 total)
I also use Robocopy but for different reasons.
For a server migration where we have UNC shares setup for app files/logs/SSIS packages etc... I use Robocopy to sync the...
July 21, 2015 at 9:09 am
If you are wanting to shrink the data file, did you select the "Shrink", "Files" and "Reorganize pages before releasing unused space" dialog box?
If you are wanting to shrink the...
July 13, 2015 at 7:00 am
When formatting a disk in windows the default blocksize is 4K. You must choose a different blocksize (64K) and format the disk for best performance for SQL. A...
July 2, 2015 at 10:36 am
If the nightly DIFF backups are not too big:
Take a FULL backup earlier in the day
Restore the FULL backups on the new server WITH NORECOVERY
Keep running your TLOG backups as...
June 23, 2015 at 2:22 pm
How many VLF's (Virtual Log Files) do you have in the transaction log of your database? A large number of VLF's could slow down the recovery of your...
June 23, 2015 at 1:44 pm
Thanks for clearing that up Gail and no disrespect meant Lynn!
Here is the actual current DL Name on MSDN: "SQL Server 2014 Enterprise Core Edition with Service Pack 1 (x64)...
June 16, 2015 at 1:33 pm
Wow I'm on the MSDN download site and there is a download with that name (I have already downloaded it). I must be tripping!
June 16, 2015 at 12:45 pm
Lynn Pettis (6/12/2015)
Welsh Corgi (6/12/2015)
GilaMonster (6/12/2015)
Welsh Corgi (6/12/2015)
So use the command line for everything?
Hell no. Use SSMS from a client machine. There's pretty much no case I can think of...
June 16, 2015 at 12:07 pm
Our numbers from our All Instances report (SQL/Server only not including Oracle, DB2, etc... No HyperV all VM's are vmWare):
Number of SQL Instances:
Physical (Prod) ...
May 8, 2015 at 6:38 am
Another approach:
Share a folder between the machines for the backup, use a static backup file name that can be reused (with INIT) and optionally use a copy only backup if...
April 9, 2015 at 7:59 am
Sorry I'm not saying that was the issue just good practice.
March 17, 2015 at 11:42 am
We use vmWare and SQL VM's (2005-2014) on Cisco blade hardware with no issues. We do have several tweaks to a SQL VM machine setup for performance reasons.
March 17, 2015 at 11:31 am
Balanced Power Plan? You want a production server to be using the "High Performance" plan to keep your cpu clocks at the maximum rated speed. At low times...
March 17, 2015 at 11:26 am
Viewing 15 posts - 46 through 60 (of 120 total)