Viewing 15 posts - 4,381 through 4,395 (of 9,244 total)
Of course!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2013 at 3:11 pm
Or empty and remove files in the current file group 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2013 at 2:30 pm
Raghavender (1/22/2013)
I need to move only some tables to other data file which is on same file group.Not the whole data file.
That's not how it works, objects can only be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2013 at 1:34 pm
jasona.work (1/21/2013)
Each individual blade in the system, is a "stand-alone" server which only shares power and connectivity with the other blades in an enclosure.
Correct, they share power cooling and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2013 at 4:22 pm
You can use dbcc shrinkfile passing in the emptyfile parameter, this will empty data from the file to other files in the same file group only. You would then need...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2013 at 1:56 pm
Failure of the public network will cause a failover of the sql server instance. You have a spare node so take the problem node out of sevice and repair the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2013 at 1:52 pm
Sean cavanagh (1/21/2013)
Helpful folks,I'm in an odd situation where, in my new job, I don't have a test cluster in which I can experiment.
No excuse, you can build a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2013 at 9:28 am
kpwimberger (1/17/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2013 at 8:35 am
MyDoggieJessie (1/20/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2013 at 5:42 am
You'll have references to the LOG folder and this is controlled by a startup parameter which sits in the registry, make sure the errorlog path is set and the default...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2013 at 5:33 am
Please post the results of this
select @@VERSION
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2013 at 3:50 am
Checking the AlwaysOn pre reqs and restrictions cites this
Ensure that each computer is running either x86 (non-WOW64) or x64 Windows Server 2008 or later versions.
WOW64 (Windows 32-bit on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2013 at 5:33 am
sp_delete_backuphistory deletes backup history from the MSDB backup history tables, it doesnt touch the filesystem!!
You're referring to xp_delete_file to achieve this
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2013 at 4:37 am
Ratheesh.K.Nair (1/17/2013)
Perry Whittle (1/17/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2013 at 4:18 am
Ratheesh.K.Nair (1/17/2013)
The thing is we need to stop the services for moving files right?
No no no, again wait for my article. This is the biggest misconception. You DO NOT have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2013 at 3:49 am
Viewing 15 posts - 4,381 through 4,395 (of 9,244 total)