Viewing 15 posts - 1,276 through 1,290 (of 1,319 total)
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.
-- You can't be late until you show up.
March 5, 2008 at 11:48 am
David, sounds like you finally got that promotion!
-- You can't be late until you show up.
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...
-- You can't be late until you show up.
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 of these...
-- You can't be late until you show up.
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...
-- You can't be late until you show up.
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...
-- You can't be late until you show up.
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...
-- You can't be late until you show up.
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...
-- You can't be late until you show up.
March 3, 2008 at 8:40 am
And a good, full backup prior to doing the defrag can't hurt!
-- You can't be late until you show up.
February 29, 2008 at 2:16 pm
Anything comparable in SQL2000??
-- You can't be late until you show up.
February 29, 2008 at 8:33 am
Not neccessarily an EBook but a searchable BOL through a browser:
http://search.live.com/macros/sql_server_user_education/booksonline
-- You can't be late until you show up.
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...
-- You can't be late until you show up.
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...
-- You can't be late until you show up.
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...
-- You can't be late until you show up.
February 28, 2008 at 1:59 pm
Jeff - I think your mistaken. Isn't it one of those new reality shows? :laugh:
-- You can't be late until you show up.
February 28, 2008 at 9:15 am
Viewing 15 posts - 1,276 through 1,290 (of 1,319 total)