Viewing 15 posts - 436 through 450 (of 1,079 total)
No risk, only adding more agility but also complexity to your restore options.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 9, 2012 at 12:09 am
What risks will involved in Backup if I include differential backup??? please suggest...
only risk is you could run out of disk space as this requires more space than a SIMPLE...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 8, 2012 at 10:16 pm
Good one thanks.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 8, 2012 at 10:14 pm
Question:
What's up with all the (some good, some weak, some short, some long) posts from:
Site OwnersDiscuss Content Posted by Unknown ...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 8, 2012 at 9:29 pm
Pleasure Giles.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 8, 2012 at 9:25 pm
Try SQL_Latin1_General_CP1_CI_AS
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 8, 2012 at 6:30 am
http://lmgtfy.com/?q=powershell+
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 7, 2012 at 10:34 pm
Depending on exactly you want to accomplish, look at the options from SQLCMD, Powershell, Dos Batch Files...
Your posts heading "....run xp_cmdshell...." and content "...dir c:..." confuse me a bit.
Warning: xp_cmdshell...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 7, 2012 at 2:59 am
Koen Verbeeck (2/5/2012)
Henrico Bekker (2/5/2012)
Thanks for the question, but please explain why:No, you can never rollback a transaction with a TRUNCATE TABLE statement, regardless of recovery mode
isn't also correct?
Because you...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 6, 2012 at 12:20 am
Thanks for the question, but please explain why:
No, you can never rollback a transaction with a TRUNCATE TABLE statement, regardless of recovery mode
isn't also correct?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 5, 2012 at 9:45 pm
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 2, 2012 at 11:01 pm
Great question, got it wrong and learnt something new.
Thanks
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 2, 2012 at 10:01 pm
Windows Cluster Management will show all events and log of service failure & node failover.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 31, 2012 at 9:38 pm
paul s-306273 (1/25/2012)
Henrico Bekker (1/24/2012)
Some people might see this as a trick question, because no where does it state "Full Backup & Shrink THE SAME database"....Good one though.
No - surely...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 25, 2012 at 2:59 am
Some people might see this as a trick question, because no where does it state "Full Backup & Shrink THE SAME database"....
Good one though.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 24, 2012 at 10:06 pm
Viewing 15 posts - 436 through 450 (of 1,079 total)