Viewing 15 posts - 5,326 through 5,340 (of 9,244 total)
laddu4700 (7/14/2012)
User db full backup job failed with below error. Anybody encountered this error. please let me know.
Message
Executed as user: domain\adsi. Microsoft (R) SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2012 at 5:37 am
GilaMonster (7/14/2012)
Welsh Corgi (7/14/2012)
When you say for the second do you mean that I would need a 3rd party tool for the SSIS Transfer of Data?
As I said, SQL column...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2012 at 5:33 am
JJ-469859 (7/14/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2012 at 10:58 am
Most of the cluster information is available from the Windows cluster itself, What information do you require?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 13, 2012 at 3:37 pm
JJ-469859 (7/13/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 13, 2012 at 3:33 pm
Bobby Glover (7/12/2012)
Thinking of upgrading to SQL 2012 maybe early next year, are there any GOTCHAs or known issues with 2012.
Which version are you upgrading from?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 13, 2012 at 6:19 am
laddu4700 (7/13/2012)
how to backup the sql 2008 database indexes? thanks
Backup your database(s) regularly and all of these objects will be backed up 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 13, 2012 at 5:07 am
TheSQLGuy (7/12/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 13, 2012 at 2:32 am
savethytrees (7/12/2012)
The following query will give...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2012 at 10:15 am
you're welcome 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2012 at 7:53 am
ananda.murugesan (7/12/2012)
1. If more then 200GB primary data file reached, I assumed need to create one more datafile for improve database perfromance?
That assumption is incorrect.
ananda.murugesan (7/12/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2012 at 7:15 am
if your secondary ever shuts down again for long periods either keep a copy of the backups that havent been restored or perform a differential on the primary and apply...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2012 at 6:46 am
you're welcome 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2012 at 6:43 am
Sorry I'm confused I thought we were discussing log shipping!!
The backup and restore information is held in MSDB, query the tables here for this info
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2012 at 1:07 am
Firstly, you seem to have a misunderstanding of files and filegroups, take a look in books online and familiarise yourself with them. Now to cover your questions
ananda.murugesan (7/12/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2012 at 1:04 am
Viewing 15 posts - 5,326 through 5,340 (of 9,244 total)