Viewing 15 posts - 841 through 855 (of 1,318 total)
steeleye1 (6/5/2015)
It seems to me that the only reason that it can be a "disaster" to share salary information is because of inequality.
Absolutely. In my personal life I am very...
June 5, 2015 at 9:20 am
See if this will help: http://www.brentozar.com/archive/2014/09/log-shipping-magic-using-differential-backup-delayed-secondary/
June 4, 2015 at 3:35 am
You could see if Brent Ozar has anything that is licensed for general use. (I don't mean rip off his stuff, but he shares a lot of really good resources...
June 3, 2015 at 7:40 am
A database requires both a data file and a log file. If you don't have a backup you might not get very far.
What happens when you try to attach the...
May 28, 2015 at 2:22 am
Interesting! Thanks for the update. It might help somebody else.
May 26, 2015 at 6:38 am
Our server names include an indicator of whether or not they are virtual. Which is fine until somebody P2Vs the server and forgets to change the name. Nothing breaks, but...
May 22, 2015 at 8:19 am
Ctrl+Shift+R will refresh the Intellisense local cache. (Or Edit > Intellisense > Refresh Local Cache.)
See if that helps?
May 22, 2015 at 8:05 am
If you'll need to read this "copy" database, log shipping might not be for you because depending on how you implement it, users either won't be able to connect, or...
May 22, 2015 at 7:57 am
If you don't set a maximum you may have the fun of seeing your server flatline because SQL Server has grabbed all of the RAM, and is starving the OS...
May 22, 2015 at 4:05 am
You're not giving much information to work with! Where's the maintenance plan from, is there anything in the SQL log to indicate what's happening, etc?
May 5, 2015 at 5:35 am
Do you mean the AG has been configured to use "Any Replica"?
Is there any sign of the backups in the msdb.dbo.backupset and msdb.dbo.backupmediafamily tables?
May 5, 2015 at 5:25 am
Has somebody configured log backups to be done on one of the secondary nodes, or something like that?
May 5, 2015 at 5:14 am
I'm not sure if I'm reading your question right, but I think you're saying you want to have only default instances when you move to SQL 2014, then create listener...
April 27, 2015 at 9:51 am
Yeah, I'd do backup/copy/restore too if possible. It can be/feel safer than doing an in-place upgrade.
Use sp_help_revlogin to script out the logins as mentioned above.
Have a read of this:...
April 27, 2015 at 9:27 am
Viewing 15 posts - 841 through 855 (of 1,318 total)