Viewing 15 posts - 1,276 through 1,290 (of 1,319 total)
As has been stated, you've added the network component into the mix. Backing up to a SAN is going to be slower than a local backup. Did you look at...
March 6, 2008 at 9:55 am
Again, see Jack's posts (linked servers is probably your easiest solution). After an honest attempt, post any issues you may have and you'll find plenty of help.
March 5, 2008 at 11:48 am
David, sounds like you finally got that promotion!
March 5, 2008 at 10:27 am
And, this has been stated numerous times in other postings, if you do a backup log dbname with truncate_only, do a full database backup immediately afterwards as you've now broken...
March 5, 2008 at 7:08 am
I know MicroSoft says these are for internal use and are subject to change without notice causing undesired behaviors (see article by Brian Moran - http://www.microsoft.com/technet/abouttn/flash/tips/tips_081705.mspx) but some...
March 4, 2008 at 12:51 pm
Can you restart the SQL services? This will flush out unneeded logins and give you a clean look at who connects and to what. What are you currently using to...
March 4, 2008 at 9:09 am
You should be doing both full backups and transaction log backups if recovery is set to "Full" mode. Perhaps full nightly (or weekly, your decision) and transaction log backups on...
March 4, 2008 at 8:11 am
That is so true of my skill set. When interviewing recently (and landing a job!!), that was how I portrayed myself - Jack of all trades, master of none. I...
March 3, 2008 at 1:06 pm
It all depends. What tasks would your colleague be expected to do? Everything your currently do? Only a small subset of what you do? If it's a subset, create a...
March 3, 2008 at 8:40 am
And a good, full backup prior to doing the defrag can't hurt!
February 29, 2008 at 2:16 pm
Not neccessarily an EBook but a searchable BOL through a browser:
http://search.live.com/macros/sql_server_user_education/booksonline
February 29, 2008 at 7:42 am
We have low volume of transactions here and a user "loss of data" threshold of one hour so the hourly log backups work fine (for now). I appreciate the quick...
February 28, 2008 at 3:05 pm
In this case the first log backup is after both full backups. So, technically, it would be the same number of logs files applied to either restore of the full...
February 28, 2008 at 2:27 pm
Just a note of caution - check all your servers and databases for backups. If something needs fixing and you're unprepared, they're going to what to know why! "I was...
February 28, 2008 at 1:59 pm
Viewing 15 posts - 1,276 through 1,290 (of 1,319 total)