Viewing 15 posts - 6,196 through 6,210 (of 9,244 total)
Jeffrey Williams 3188 (12/13/2011)
Or - look at creating a Powershell script instead of VB script. That can also be called from an agent job directly.
Good call 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 14, 2011 at 1:42 am
This is an ideal scenario for creating package configurations. when creating a configuration elect to use SQL Server roles and security. Export your chosen connection string objects and they are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 14, 2011 at 1:40 am
Sean Grebey-262535 (12/13/2011)
Shrink finished after about 2 hours.
How much free space did you leave?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 13, 2011 at 2:36 pm
The Enterprise eval is for exactly that, not for testing your apps\software releases. I'm sure that's in the EULA somewhere!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 13, 2011 at 12:26 pm
Chrissy321 (12/13/2011)
I have xp_cmdshell available on this server
No xp_cmdshell, just execute the vb script from a SQL server agent job step
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 13, 2011 at 12:24 pm
homebrew01 (12/12/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 13, 2011 at 11:23 am
Tristan Chiappisi (12/13/2011)
I'm looking for a solution for moving large files across data centers (in the sense of making it faster). Has anyone had much luck with any programs out...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 13, 2011 at 11:21 am
vkr.karthick (12/13/2011)
I tried download from Microsoft site but could do only...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 13, 2011 at 11:06 am
it all depends on which other options you selected in the GUI, for instance did you elect to "reorganise pages before releasing unused space"?
Remember to leave enough free space...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 13, 2011 at 11:04 am
better option would be to use scripted T-SQL jobs, the BACKUP DATABASE command has a MIRROR TO clause which can be used to mirror backups. A lightweight VB script can...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 13, 2011 at 10:59 am
this question has been raised before, yes it is possible but there are caveats around it
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 12, 2011 at 6:57 am
Hi sorry, my bad totally missed the cluster part. Yes for a new clustered instance you will need to add another root drive and letter to the new application group
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2011 at 10:46 am
kellithompson (12/9/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2011 at 8:20 am
Pierre Boucher (12/8/2011)
- Should I allocate multiple files for each FILEGROUP so that our SAN can distribute the I/O?
It's not a given, and in fact for user databases...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2011 at 2:25 am
if you only want to keep one log file you dont have a choice which one, you must keep the log file with file id of 2, delete all others...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2011 at 1:53 am
Viewing 15 posts - 6,196 through 6,210 (of 9,244 total)