Viewing 15 posts - 4,381 through 4,395 (of 9,241 total)
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
That's the order i prefer to do it in. Set the paths and confirm that sql server has updated the system catalogs, you will receive a meesage indicating that the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2013 at 3:44 am
Well, if you really can't wait for my guide to be published perform the following;
get details of the current paths\filenames using this query
select name, physical_name from sys.master_files where database_id =...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2013 at 3:24 am
Ratheesh.K.Nair (1/17/2013)
I tried moving one of our user DB using
1.mode database offline..moved files run alter database modify files and made database online..it didnt took old .ldf file instead...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2013 at 3:08 am
Viewing 15 posts - 4,381 through 4,395 (of 9,241 total)